ManicMax Posted April 19, 2008 Share Posted April 19, 2008 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' Quote Link to comment Share on other sites More sharing options...
ohdang888 Posted April 19, 2008 Share Posted April 19, 2008 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? Quote Link to comment Share on other sites More sharing options...
ManicMax Posted April 19, 2008 Author Share Posted April 19, 2008 yes, im also running it directly in phpmyadmin and it says 0 rows affected ran in 0.022 seconds Quote Link to comment Share on other sites More sharing options...
Fadion Posted April 19, 2008 Share Posted April 19, 2008 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. Quote Link to comment Share on other sites More sharing options...
chigley Posted April 19, 2008 Share Posted April 19, 2008 What field type is date? Quote Link to comment Share on other sites More sharing options...
Fadion Posted April 19, 2008 Share Posted April 19, 2008 What field type is date? If the question was for me: Mysql Data Types, like "date" or "time"!!! See the manual If not sorry Quote Link to comment Share on other sites More sharing options...
chigley Posted April 19, 2008 Share Posted April 19, 2008 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 Quote Link to comment Share on other sites More sharing options...
ManicMax Posted April 19, 2008 Author Share Posted April 19, 2008 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 Quote Link to comment Share on other sites More sharing options...
chigley Posted April 19, 2008 Share Posted April 19, 2008 UPDATE calendar SET am700='1', am730='1' WHERE date='14/04/08' Quote Link to comment Share on other sites More sharing options...
ManicMax Posted April 19, 2008 Author Share Posted April 19, 2008 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? Quote Link to comment Share on other sites More sharing options...
chigley Posted April 19, 2008 Share Posted April 19, 2008 Just below the bottom post, and a bit to the left is a "Topic Solved" button Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.