unexpected '='

[aebstract]

[code]
result = mysql_query("SELECT * FROM friendslist WHERE userid = '$id'")
while($r=mysql_fetch_array($result))  {  
$friendsid=$r["friendsid"];  


$result2 = mysql_query("SELECT * FROM accounts WHERE id = '$friendsid' ORDER BY username DESC")
while($r2=mysql_fetch_array($result2))  {  
$username2=$r2["username"];  

$content .= "

$username2<br />

";
}
}
[/code]

It's suppose to find out who is in your friendslist (a table with three columns flid (auto increment), userid (your personal id), and friendsid (their id). Should find the rows that match up with your id, then find the usernames of their id through the accounts table. If theres an easier way to do this that im missing let me know, but why the unexpected '='?

Parse error: syntax error, unexpected '=' in /home/.jaguar/onelastromance/carbenco.com/beta/pmbox.php on line 319

319 is while($r=mysql_fetch_array($result)) {

[poirot]

You missed a semi-colon on line 318 then.

[aebstract]

lol, thanks