While Loop (display all data in a column)

[markvaughn2006]

I know this is simple, but all the while loop examples show you how to count to ten and then stop looping when it is greater than 10.

I just need a while loop to display all data in a column and stop when it gets to the bottom.

This is my jacked up attempt to display all usernames in the user_name column. Also how would I go about putting a <br> in between each echo? Thanks much!

 

$result = mysql_query("SELECT user_name FROM users_tbl'") or die(mysql_error()); 

while $row = mysql_fetch_array( $result );

 

echo $row['user_name'];

[Mark Baker]

$result = mysql_query("SELECT user_name FROM users_tbl") 
   or die(mysql_error());  
while ($row = mysql_fetch_array($result)) {
   echo $row['user_name'];
   echo '<br />';
}

[kickstart]

Hi

 

Assuming you mean one username per row (rather than a row having multiple user names which you want to split up):-

 

$result = mysql_query("SELECT user_name FROM users_tbl'") or die(mysql_error());  
while ($row = mysql_fetch_array( $result ))
{
echo $row['user_name'].'<br />';
}

 

All the best

 

Keith

[markvaughn2006]

awesome, thanks!