PHP & mySQL syntax problem

[TapeGun007]

I posted in here, because I know the SQL is correct.

 

When I do this in phpMyAdmin, this works great:

Update Leads SET FollowUpDate='2011-08-18' WHERE FollowUpDate<'2011-08-18'

 

But in PHP I have the code written (and I've tried several different ways):

 

$TodaysDate = date("Y.m.d");
$statement="Update Leads SET FollowUpDate='$TodaysDate' WHERE FollowUpDate<'$TodaysDate'";

 

When I execute the SQL above, it actually resets all the dates to 0000-00-00... ug.  What is the correct syntax?

 

Thanks.

[TeNDoLLA]

This

$TodaysDate = date("Y.m.d");

 

should probably be

$TodaysDate = date("Y-m-d");

so the date will be in the correct format (YYYY-MM-DD, not YYYY.MM.DD) for the mysql field.

[TapeGun007]

Yes, you are correct.  However, now it simply does not update anything.

 

Also, I did a

echo $statement;

 

And I get this:

Update Leads SET FollowUpDate='2011-08-18' WHERE FollowUpDate<'2011-08-18'

 

I purposely changed one date in phpMyAdmin to 2011-08-17, and it's not updating that record to 2011-08-18.  Yet that nearly same command works fine in the SQL area of phpMyAdmin.  So I am confused, must be improper syntax.

 

 

[PFMaBiSmAd]

Are you actually executing the query in your php code? Do you have any error checking and error reporting logic in your php code that would tell you if and why the query is failing?

[TapeGun007]

I had remarked the execution out to back track and forgot to put it back in.

 

It works now.  My bad.