Displaying each row seperate

Schwalbach

Ok guys, I am having a MAJOR brain block, and for some reason, I can't seem to get this?

Could you tell me how to select each item of my database one by one and display them: here is my code, and you will see the reasoning:

$sql = "SELECT * FROM useronline";
$result=mysql_query($sql);
$numrows = mysql_num_rows($result);
echo("&users=");
for($i=0;$i<$numrows;$i++) {
$result = mysql_query("SELECT * FROM useronline ORDER by timestamp desc limit $i,1"); 
while ( $row = mysql_fetch_array($result, MYSQL_ASSOC) Or die(mysql_error()) ) {
echo("<u>".$row['Username']."</u>  ");
}
}

See, I need to put the in between each seperate item, but it is only showing the first item, not the second one(only showing one username, instead of all the ones that should be on there)

Thanks alot guys

yelvington

Why are you banging on the database for every line?

Select the entire result set, then do your output formatting in PHP.

(untested code)

$sql = "SELECT * FROM useronline ORDER BY timestamp DESC";
if (!$result=mysql_query($sql))
   die(mysql_error());
echo("&users=");
while ($row=mysql_fetch_array($result) )
    echo("<u>$row[Username]</u>");

Schwalbach

Because, Like before, that displays all the rows, not each one seperate.

Using
echo("$row[Username] ");

I still get the output of
MyNameYourname

instead of

MyName Yourname

Like I am looking for

mrhappiness

while ($row=mysql_fetch_array($result) )
        echo("<u>$row[Username]</u> ");

should do it and you query the database only once

Schwalbach

I don't understand? You guys have told me the same thing twice now

Using
echo("$row[Username] ");

If you read my above post, I am using that, and I still get the wrong output?

laserlight

yelvington suggested that you cut short the number of queries by modifying the query.
You should then be able to manipulate the result set to display one by one.
On the other hand, mrhappiness doesnt know what he/she is talking about.

I wonder if this will work:

$sql = "SELECT * FROM useronline ORDER BY timestamp DESC";
$result = mysql_query($sql)
	OR die(mysql_error());
echo "&users=";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	echo "<u>" . $row['Username']. "</u>&nbsp;";
}