quotation nightmare

[jeff5656]

I have the " or the ' all wrong.  Can someone tell me how to do the quoation marks correctly so I dont get a syntax error:

 

as can be seen, the date 10/5/14 is not a variable but I want to convert it to a format that can go into a DATE field.

 

$query = "update table set expir_date = date("Y-m-d", 10/5/14) where id = '$id' ";

[Maq]

It's easiest if you break out of the string to use the date() function.  I also added single quotes around the date value:

$query = "update table set expir_date = '" . date("Y-m-d", "10/5/14") . "' where id = '$id' ";

[jeff5656]

Wait, don't I need strtotime?  I got 0000-00-00 when I did that.  Where would the quotes go:

 

like this?

 

$query = "update table set expir_date = '" . date("Y-m-d", strtotime("10/5/14")) . "' where id = '$id' ";

[Maq]

Wait, don't I need strtotime?  I got 0000-00-00 when I did that.  Where would the quotes go:

 

like this?

 

$query = "update table set expir_date = '" . date("Y-m-d", strtotime("10/5/14")) . "' where id = '$id' ";

Yes sorry, like that.  Echo out $query to see exactly what the string looks like, it will give you a better idea.

[jeff5656]

Thanks!