How to Loop a Query

[Smee]

Hey All,

 

I'm new to PHP and was wondering if someone could help me out.

 

Im currently creating a friends list that shows added friends to users that are logged in.

 

^<?php

 

^{$result = mysql_query ("SELECT * FROM friends WHERE me = '$username'");}

 

^{($row = mysql_fetch_array($result));}

 

^{echo " <b>Username:</b> $row[friend] </br> ";}

 

^?>

 

Above is the query i created that shows my freinds but because of the setup of SQL database i am only getting one result showing.

 

SQL database is setup like this:

 

      me          friend

 

  username  friendsusername

 

When multiple usernames are the same it only shows the most current friend when displayed on my main page.

 

I have tried to do some while loops but to no avail. Bascally i just need to keep it as simple as possible but display all friends under a certain username.

 

Thanks for any help

 

Smee

[premiso]

while ($row = mysql_fetch_assoc($result)) {
   echo " <b>Username:</b>   {$row['friend']} </br> ";
}

 

A while loop is what you were after.

[Prismatic]

edit - dangit premiso :|

 

 

[Smee]

Wow that was easy.. Thanks for that

 

Cant belive all i didn't put was the {} around $row['friend'] when i was trying so many variations!

 

dont suppose you could explain why they are needed there?

 

Thanks again

[marcus]

You also forgot to make it a while loop, lol. The curly braces are just another form of escaping variables.