* Anthony R. J. Ball
> I am trying to figure out the best way to select
> the row of data for a specific id that is the most
> recent entry on or before a specific date.
What about:
SELECT * FROM table
WHERE
id = $specific_id AND
date <= '$specific_date'
ORDER BY date DESC
LIMIT 1
--
Roger
query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
