MySQL ORDER BY id

[Anon]

Hello,
is there anyone that knows MySQL and PHP4 (or 3 i guess) very well? I am building a free for all links script and i need the newest links added to the top of the page and can not do it. I can sort the links by using ORDER BY id but it orders them the way they already are, like 1,2,3,4 and so on (1 being the oldest). What I need is someway to get it to go 4,3,2,1 (with the oldest on the bottom) or have 1 the newest and move all the rest down some how.

[jc94062]

As before, ORDER BY id DESC :-)

[Anon]

$query = mysql_query("SELECT * FROM tablename");

// you need to find out how many rows there are.
$rows = mysql_num_rows($query);

$i = $rows;

while ($rows < $i) {

$query = mysql_query("SELECT id FROM tablename");
echo mysql_result($query, $i);

$rows++;
}

I think that will reverse the output from 1,2,3,4 to 4,3,2,1

If its not, its something in the while loop.

The mysql code is correct as far as i know!

Mark

[Anon]

oo ok,
i get it now. Thandx a bunch..IT WORKED! LoL. Now i can continue on with my work. Thanx a bunch.

[jc94062]

Why make it harder?

ORDER BY id DESC works so much easier!