order by problem

[psychohagis]

ive got this expression to work:

[code]$messages = @mysql_query(
  'SELECT mid, from1, subject, message, received, read1, username
FROM messages, users
WHERE to1 ='.$userid.' AND from1 = users.id LIMIT 0 , 30 ');[/code]

But I know want to add [b]ORDER BY mid DESC[/b]. but when I do it complains as follows:

[quote]Error performing query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mid DESC' at line 4[/quote]

[utexas_pjm]

The ORDER BY clause must come before the LIMIT clause.  More precisely:

[code]
$messages = @mysql_query(
  'SELECT mid, from1, subject, message, received, read1, username
FROM messages, users
WHERE to1 ='.$userid.' AND from1 = users.id ORDER BY mid DESC LIMIT 0 , 30 ');
[/code]
Will work, while
[code]
$messages = @mysql_query(
  'SELECT mid, from1, subject, message, received, read1, username
FROM messages, users
WHERE to1 ='.$userid.' AND from1 = users.id LIMIT 0 , 30 ORDER BY mid DESC ');
[/code]
will not.

Best,

Patrick