SQL_Query Username Block help

New Member Joined: Feb 02, 2007 Posts: 24

I am trying to create a block to show the current users in our chat module. I can get it to show the first person Alphabetically, but it will not list the rest. Here is the code I have currently.

Code:

//Function to call users in chat


$user_display = 'SELECT * FROM '.$prefix.'_live_online ORDER BY '.$prefix.'_live_online.`username` ASC';


$online_results = $db->sql_query($user_display);


list($chat_users_online) = $db->sql_fetchrow($online_results);





$content ="<BR><center>Who's Chatting:<BR> ";


$content .=$chat_users_online;


$content .="</center>";

Anyone know what commands I need to use to show more than the first person? Thanks.

Posted: Sat Jun 21, 2008 8:53 pm

You will need a while loop to go through every row with sql_fetchrow until there are no more returned. There are numerous examples on how to do this in PHP

Involved Joined: Apr 06, 2008 Posts: 484

something like this,

Code:




global $prefix, $db;


//Function to call users in chat


$user_display = 'SELECT username FROM '.$prefix.'_live_online ORDER BY username DESC LIMIT 0,5';


$results = $db->sql_query($user_display);


$content ="<br /><center><strong>Who's Chatting:</strong><br /><br /> ";


if ($db->sql_numrows($result)) {


   while (list($username) = $db->sql_fetchrow($result)) {


   $content .= '<div>'.$username.'</div>';


   }


   } else {


   $content .= 'No Ones Chatting';


   }


   $content .="</center>";

Posted: Sun Jun 22, 2008 9:15 am

You are awesome testy1... that worked like a charm.

I was racking my brain searching for the structure to accomplish this.

Posted: Sun Jun 22, 2008 3:52 pm

even though i know how to use "while" it's one of those things that i always stuff up and have to go back and check lol, glad it worked

the only thing to change will be how many it displays, if you want more than 5 change the 5 below to how ever many you want .

Code:




LIMIT 0,5