looping through multiple rows

[mg542]

ok, im trying to write a PM system for my game and i have it so you can select someone to send a message to and they can recieve it. but how would i make it so that it would display every message instead of just one...i know it has something to do with looping through multiple rows but i dont know the exact code i should use.

[Shock_CNOP]

You can use a while loop for that. It's pretty easy too.

It should go something like this:

$query_pms = "SELECT * FROM privatemessages WHERE to='{$to_username}'";
$sql_pms = mysql_query($query_pms);

# Start while loop.
// Note the single equals character in the following line.
while ($row_pms = mysql_fetch_array($sql_pms))
{
# Display list of private messages using the variables in the $row_pms array.
}

[mg542]

you know, im a retard, i used that exact same syntax in my list of people that you can send a PM to. 😛 well thanks alot....i never think of the obvious.