[thelist] mysql query syntax using max(id)

[Anthony Baratta]

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
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."