Updating Database

SPetty

New issue i'm having. I have a TIMESTAMP field in MySQL, and what i'm trying to do once i've compared new data to that timestamp, I want it updated with a new timestamp.

Here is the code i've used.

$email_number = $row['email_id'];
$new_date = date("Y m d H i s");

$update_last_email = "UPDATE mailing_list SET last_email = '" .$new_date. "' WHERE email_id ='" .$email_number. "'";

No errors, however this is not updating the database columns. Any ideas where I've gone wrong. Let me know if you need more information.

Thanks
Shawn

bpat1434

Why not just use the mySQL function NOW() to give you the timestamp. So your query becomes:

UPDATE mailing_list
SET last_email=NOW()
WHERE email_id='$email_number'

If that doesn't work, can we see more of the script?

gardnc

Not sure either. Are you running the query, you don't show that code? Assuming the table column names are correct and the varaibles are what you need then the insert should work. Below that code you should have a mysql_query($update_last_email); also above it a connection to the database.

If all above is correct, then try putting a "echo $update_last_email;exit;" right after you set the variable $update_last_email and you should see the query that is going to be run. Copy it to a command line or other interface to MySQL and execute it to see if the query is correct.

SPetty

bpat: I originally had the now() function in the code. It did not update then either.

gardnc: I had the mysql_query($update_last_email) a couple lines down but forgot to include it in the original post.

I actually was running the update manually in PHPMyAdmin and that's where I took the code to update from, so I was assuming it would be golden..but hmmmmm......

Here is the echo I get from $update_last_email.

UPDATE mailing_list SET last_email = '2006 03 22 18 15 33' WHERE email_id ='4'

Seems to be correct as far as I can tell. Connection is also set as I am echoing the other pieces of code I am writing to get this automated mailing list working.

EDIT:

Ahhh, the format of date() wasn't matching up with the timestamp in MySQL. Everything updated this time.

bpat1434

I was about to say that..... that's why the NOW() function would be better served in this position. mySQL would format it properly based upon the type of column.. But whatever works....