mysql_fetch_array（）TOP（10）的问题[重复]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

trying to make a compliments area of my test site

$result = mysql_query("SELECT message, username FROM compliments order by date DESC");
while($r = mysql_fetch_array($result))    
{
    $Name = $r["username"];
    $Message = $r["message"];
}

this however, gets all the messages,

i want to limit to only the most recent 10

so i tried this..

$result = mysql_query("SELECT TOP(10) message, username FROM compliments order by date ASC");
while($r = mysql_fetch_array($result))    
{
    $Name = $r["username"];
    $Message = $r["message"];
}

throws an error

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/localhost/httpdocs/readcompliments.php on line 52

how can i do this successfuly?

EDIT:

Now using

SELECT  message, username FROM compliments order by date ASC LIMIT 10

and it works! but the problem is, that its getting the oldest 10! how do i make it so it gets the most recent 10?

</div>

Answer 1

IF you are using Mysql

TOP is for sqlServer,LIMIT for Mysql

SELECT  message, username FROM compliments order by date ASC LIMIT 10

Instead of

SELECT TOP(10) message, username FROM compliments order by date ASC

EDIT

If you want to get most recent 10,You can use order by date DESC

SELECT  message, username FROM compliments order by date DESC LIMIT 10