2 replies to this topic

[c1rca]

Basically, i am making a website for a gaming team that i run and in my user database i have a field called 'css_team' with enum and the fields set as Y and N. Basically, the default is N and the players in my team are set to N.

I am creating a roster panel on the main page and i want it to just show the usernames of the ones with the 'css_team' field value as Y.

Could anyone help me with this?

[David Knight]

This can be controlled with a simple sql query:

SELECT * FROM users WHERE css_team = 'N'

The full script would look something like this:

<?php
	$query  = "SELECT * FROM users WHERE css_team = 'Y'";
	$result = mysql_query($query);

	while($row = mysql_fetch_array($result)) {
?>
	<b>Name</b> - <?php echo $row['name']; ?>
<?php
	}
?>

Hope this helps.

[c1rca]

Lucias O`Neil, on Dec 13 2007, 09:57 PM, said:

This can be controlled with a simple sql query:

SELECT * FROM users WHERE css_team = 'N'

The full script would look something like this:

<?php
$query = "SELECT * FROM users WHERE css_team = 'Y'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {
?>
<b>Name</b> - <?php echo $row['name']; ?>
<?php
}
?>

Hope this helps.

Thanks, i'll try that out tomorrow.