[UPHPU] find latest date

Wade Preston Shearer groups at anavidesign.com
Wed Aug 25 21:00:57 MDT 2004


> To just get the one you want:
>
> ORDERBY datetime ASC/DESC LIMIT 1

This should work (thanks Jeremy and Steve), but I do have one more 
question...

To be more specific, what I really need is to retrieve the latest date 
ONLY if there is a date for all site fields. So, would I have to 
retrieve them all instead and verify that the six strings were not 
empty first, or is there a way to test for empty fields with MySQL in 
the query?




More information about the UPHPU mailing list