[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