[thelist] mysql query syntax using max(id)

Anthony Baratta Anthony at Baratta.com
Sun Oct 6 00:17:01 CDT 2002

At 08:01 PM 10/5/2002, Anthony Baratta wrote:
>At 07:42 PM 10/5/2002, George Fitzsimmons wrote:
>>[ Picked text/plain from multipart/alternative ]
>>I can't seem to get the syntax right for this mySQL query:
>>$query = "SELECT news_id, news_article FROM sb_news WHERE news_id =
>>max(news_id) limit 1";
>Here ya go....
>SELECT Max(news_id) as news_id, news_article from sb_news

Ignore me, I don't know what the h#ll I'm talking about tonight. ;-P

(Rudy, Rudy, he's the man.....yada yada yada ;-)

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list