[RESOLVED] more join problems

[zcollvee]

$query = "
   SELECT `updates`.`content`, `updates` . `update_id`, `updates`.`date`, `updates`.`frm`, `updates`.`username`
      FROM `updates`  ORDER BY `updates` . `update_id`DESC
         INNER JOIN `star` ON `updates`.`username` = `star`.`friended`
      WHERE `star`.`username` = '" . $id . "'
      LIMIT 10 
"; 
$result = mysql_query($query) or die(mysql_error());
echo '<table>';
while(list($content, $uid, $date, $frm, $username) = mysql_fetch_row($result)){
{

blablabla
}

Its the ORDER BY command thats causing problems because without the order by it works fine.
I just need to order all the updates from your friends list by the newest ID and then LIMIT it to 10. A swift reply would be appreciated 😃

[leatherback]

You need to move the order by statement to after the where statement.

select ... from ... where ... order by ... limit ....

[zcollvee]

thanks