Select statement

[Chris_Evans]

index.php
$result = mysql_query("select * from news") or
	die (mysql_error());

Ok - the above retrieves all records from the database called news, correct?

Well, it does, so... how can I retrieve a selected number of records in order? I have an ID field in which each record is given a unique id so how can I retrieve from that id in order. So for instance... 0 is last. 1 is second. 2 is third. So if I had three articles, the article number 3 with id 2 would be at the top?

Thanks,

Chris

[kristianblom]

select * from news order by id desc

if you jus want to get th 5 last...

select * from news order by id desc limit 5

but you should consider using a date to order by instead...

[jpmoriarty]

oh and just to be really pedantic...

it actually selects everything from the table news, not the database - you have to specify what database you're using earlier on.

But thats just me being picky...

[Chris_Evans]

Already did that! 😃 😃 he he! 🙂 Good point though... I created a file called dbconnect.php... every file that requires the database has an include with this file! 😉