Hi all,
 
 
$query=mysql_query("select * from newsa ORDER BY id DESC LIMIT 3");
 
while ($row = mysql_fetch_array($query)) {
echo"..............
 
if we say the id of rows goes from 1 to 100, so the last row's id is 100,
 
this code displays the results for the ids as follows:
 
row with id 98
row with id 99
row with id 100
 
The question is, I want it to display as :
 
row with id 100
row with id 99
row with id 98
 
How can I achieve this?
 
(if i try ASC instead of DESC it displays rows with ids 1,2,3 - that is not 
what I want)


      
____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

[Non-text portions of this message have been removed]

Reply via email to