PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$newuser="SELECT DISTINCT user FROM table WHERE td='$td'";
$query=mysql_query($newuser)
while ($row = mysql_fetch_assoc($query)) {
$username=' '.$row['user'];
;
that results in two entries beside eachother when I echo $username.
I need to create another statement that individually handles each entry. My goal is to be able to check the database for the next available user online so I can replace it in the database. I have a count if one of the users is online but will this even work the way I want it to? Any help greatly appreciated?
thanks for the response man, I was making a major noob mistake. I thought that the best thing was to query for multiple entries and somehow make the next statement handle multiple results but what I did was query for a minimum value and then have the php basically loop and delete values that were unnecessary until the right value is reached that is under active users.