[SOLVED] Mysql Query Running but not working!?!?

[ManicMax]

Here is the mysql query and it is running I have an or die on the end and it doesnt die.

 

is something in my syntax wrong???

UPDATE calendar SET am700='1' AND am730='1' WHERE date='14/04/08'

[ohdang888]

mysql query("UPDATE calendar SET am700='1' AND am730='1' WHERE date='14/04/08' ") or die(mysql_error);

 

i know that sounds stuupid, but is your syntax in the mysql query?

[ManicMax]

yes, im also running it directly in phpmyadmin and it says 0 rows affected ran in 0.022 seconds

[Fadion]

If your `date` mysql column is varchar then check if that date exists, but if your columns is of type 'date' then the format is YYYY-MM-DD.

[chigley]

What field type is date?

[Fadion]

What field type is date?

 

If the question was for me: Mysql Data Types, like "date" or "time"!!! See the manual

 

If not sorry

[chigley]

What field type is date?

 

If the question was for me: Mysql Data Types, like "date" or "time"!!! See the manual

 

If not sorry.

 

Nah it was aimed at the OP

[ManicMax]

it is only letting me update one field at a time. Date field is varchar. the query will only work if i update one field at a time

[chigley]

UPDATE calendar SET am700='1', am730='1' WHERE date='14/04/08'

[ManicMax]

Your a start chigley you really are!!

 

Thats two problems solved by you today ok make it three how do I change the subject title and image of this post to be solved?

[chigley]

Just below the bottom post, and a bit to the left is a "Topic Solved" button