[thelist] SELECTing and auto_increment field

Bill Haenel bill at webmarketingworx.com
Thu Sep 13 18:59:14 CDT 2001


> Wouldn't it just be a
>
> SELECT  id, whatever_else, unix_timestamp(your_col)  AS time
> FROM your_table
> ORDER BY time DESC LIMIT 1

I dunno. Would it? If so, boy do I feel dumb. Okay, then what would you do
to use that last timestamp in the (assumed) array? In other words, you've
sorted the results, now how do you say "gimme the biggest one"?


> I'm not hot enough with sql to even
> think the above would work without testing;

Me neither. That's why I'm on this list.





More information about the thelist mailing list