Re: Get the record with the latest date

Hi Brian, > Man, this took me two hours to figure out, but in the end, this worked! > SELECT ... max(date_time) ... It /appeared/ to work, but with different test data you should see that it isn't guaranteed to. Try inserting: INSERT INTO completed_modules (module_id, email, score, dat

RE: Get the record with the latest date

d and was driving me crazy. Seems simple now but... yikes! Thanks for everyone's help on this! -Brian -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Saturday, May 27, 2006 9:53 PM To: Brian Menke Cc: mysql@lists.mysql.com Subject: Re: Get the record with

Re: Get the record with the latest date

Brian Menke wrote: Sorry about the last post, I hope this one comes over better. This is a bit embarrassing because I think this should be a simple WHERE clause, but it escapes me at the moment. I have a table with data: module_id emailscore date_time 1 [EMAIL PROTECTED] 8

Get the record with the latest date

Sorry about the last post, I hope this one comes over better. This is a bit embarrassing because I think this should be a simple WHERE clause, but it escapes me at the moment. I have a table with data: module_id email score date_time 1

Get the record with the latest date

This is a bit embarrassing because I think this should be a simple WHERE clause, but it escapes me at the moment. I have a table with data: module_id email score date_time 1 [EMAIL PROTECTED] 8 5/27/2006 12:07 AM 1 [EMAIL PROTECTED] 9 5/27/2006 12:11 AM 1 [EMAIL PROTECTED]