can't you select the latest timestamp? On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote:
> Greetings- > > I have a MySQL database with a table (job_table) containing information > concerning jobs I run. Among the fields on the table are job_id > (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry > to the table with the job_id, timestamp, and associated information, so the > table contains multiple entries for any given job_id. I would like to be > able to run a select on the table to retrieve the latest entry for each > job_id so I can display a "latest status" message for every job. How do I > (assuming that I can) construct the SELECT statement to do this? > > Thanks! > > Greg Lindstrom > Acxiom Corporation, mail: CWY10011149 > InfoBase Products Development office: (501) 342-1626 > 301 Industrial Blvd, Conway, AR, 72032 fax: (501) 336-3911 > email: [EMAIL PROTECTED] > > "Programming requires discipline. Period. If you're depending on a compiler > to catch sloppy thinking, then you've got trouble." John Roth > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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