[php][mysql]Display Highest news id

[Zaxza]

I have a php/mysql news management system, and on my main page i want to display my latest news. Basically i need to include the page with the highest news id my pages are set like this:

"news.php?newsid=21"

Is there a way to do this?

[bwh2]

you need your query to be something like:

$result = mysql_query( "SELECT * FROM newstable LIMIT limitnum ORDER BY newsid ASC" )'

without knowing what your tables or variables are called, that's my best guess. basically you just need to ORDER BY

[skOOb]

if you want the highest id's first, you would use

SELECT * FROM newstable ORDER BY newsid DESC LIMIT limitnum

(also the limit must come after order by)

hth

[Zaxza]

I only want to show the highest news id, there will be links to the others...

[bwh2]

then LIMIT 1

@skoob: word. i couldn't remember the syntax off hand.

[Seb Hughes]

Would it be ordered by DESC? To get the latest news?

[skOOb]

you should really have a datetime field on the news entry. like "date_added" or something, and use that for ordering. using an auto_increment ID could work...but it won't work if for some reason you insert an ID manually to a lower available news ID.

@ sebs - Since the news ID will be 1 more than the previous news story, it will have a greater number, and you want to sort from highest to lowest to get the most recent news story added.

[Seb Hughes]

you should really have a datetime field on the news entry. like "date_added" or something, and use that for ordering. using an auto_increment ID could work...but it won't work if for some reason you insert an ID manually to a lower available news ID.

@ sebs - Since the news ID will be 1 more than the previous news story, it will have a greater number, and you want to sort from highest to lowest to get the most recent news story added.

Yes skoob that would be DESC and type in number going doen

1
2
3
4

and sort by DESC 4 would be at the top, that woudl be the newest story.

[zyklone]

try this sql statement:

$result=mysql_query("select max(id) as maxID from tbltable");
$row=mysql_fetch_object($result);

echo $row->maxID;

this would output the maximum id number in the database