1 reply to this topic

[dEcade]

Okay say I have a script like this:

<?php
$result = mysql_query("SELECT * FROM table name ORDER BY ID DESC");
while($row = mysql_fetch_array($result))
{
echo $row['id'];
}
?>

how can I am all of the ids go down instead of starting with 1 - 10 be like 10 all the way down to 1.

I hope I make sense

EDIT %< Got it to work

dEcade

Edited by dEcade, 14 July 2005 - 04:22 PM.

[Jaymz]

<?php
$result = mysql_query("SELECT * FROM table name WHERE id<10 ORDER BY ID DESC LIMIT 0,10");
while($row = mysql_fetch_array($result))
{
echo $row['id'];
}
?>