Trouble with a simple SQL statement

[MyTool]

I know this sounds retarded.

But I want to find a way I can single out the higest rating quote on my website through an SQL statement.

For the life of me I can't think of a way to get the higest rating singled out from the rest.

$sql = 'SELECT * FROM `quotes` ORDER BY `id` where `rating` This is where I get stuck ';

What on earth would you put here?

Help please

 

[r937]

SELECT * 
  FROM quotes 
 WHERE rating =
       ( SELECT MAX(rating)
           FROM quotes )

in ANSI SQL, the backticks will give a syntax error

next time, you might wish to try forum436

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon