[RESOLVED] help fix my code please

jasondavis


$sql2="INSERT INTO friend_featuredusers (user_id, featured, startdate, enddate) VALUES ($userid, '1', NOW(), DATE_ADD(NOW(), INTERVAL 30 DAY))";

executeUpdate($sql2);

I have this code above that inserts a record into the DB and the enddate value is set to 30 days from current date, What I want to do is if a record exist I want to update that record by taking the value of enddate and increasing it by 30 days.

I tried this code below but it sets enddate to this 0000-00-00 00:00:00
any help greatly appreciated

$sql="update friend_featuredusers set enddate='DATE_ADD(NOW(), INTERVAL 30 DAY' where user_id=$userid"; 
executeUpdate($sql);

bradgrafelman

Remove the quotes around the DATE_ADD() function - you're not trying to store that as text, you're trying to execute a function. You're also missing the closing ')' for that function as well.

jasondavis

thanks that fixes some of the problem the result is now 2008-01-13 22:26:34 but when I redo the process instead of adding 30 days to 2008-01-13 22:26:34 it remains the same, my guess, do I need to replace the part that says NOW() with the result that is stored in enddate

jasondavis

my new result is

update friend_featuredusers set enddate=DATE_ADD(2010-02-19 21:33:12, INTERVAL 30 DAY) where user_id=1

which gives me this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '21:33:12, INTERVAL 30 DAY) where user_id=1' at line 1

bradgrafelman

That's because you didn't surround the string in quotes. Instead of hard coding the value, though, you could just name the column:

update friend_featuredusers set enddate=DATE_ADD(enddate, INTERVAL 30 DAY) where user_id=1

jasondavis

awsome thanks

bradgrafelman

Don't forget to mark this thread resolved.