Jump to content

Return highest field number from query?


Prismatic

Recommended Posts

Im having a big brain fart on this one  :P

I have a table setup like this

[quote]
[u]message_id | chat_id | user_id | user_name | message | post_time[/u]
233          |1          |10        |Bob          |Test        |2006-09-26 16:11:02
234          |1          |10        |Bob          |Weee      |2006-09-26 16:12:32
235          |1          |10        |Bob          |Arr!        |2006-09-26 16:14:56
etc..
[/quote]

What I need to do is run a query to grab the HIGHEST message_id in the table, anyone know what a query like that would look like? Sorry, im having a bad day heh

Thanks!


Link to comment
https://forums.phpfreaks.com/topic/22183-return-highest-field-number-from-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.