going slightly mad...

flatpooks

so i have a simple sql insert statement:

insert into customers (fname,lname,ssn,dln,dl_image,date_added,user_id,account_id,notes) values ('susan','smith','54321','9876','dl_5_1081207650.jpg',now(),1,5,'notes')

that fails when executed from my php code mysql_query(...)

the statement works from the command line and from the various sql admin shells out there ... the db connection has been established etc etc

the error message from mysql is that there is a syntax error near '' at line 1 ... not terribly helpful

if anybody has any clues please share them cos im going slightly mad

thnx
🙂

sidney

you have a single quotea missing from now()

flatpooks

ummmmmm using now() in a query doesnt require quotes afaik ... at least it never has before??? i tried it anyways and it made no difference

sidney

somthing like that or maybe now() just with out quotes

  "insert into customers (fname,lname,ssn,dln,dl_image,date_added,user_id,a
ccount_id,notes) values ('susan','smith','54321','9876','dl_5_1081207650.jpg','".now()."','1','5','notes')"

flatpooks

errrrrr that would execute the now() function in PHP and it doesnt exist in PHP ... it needs to get sent to the database engine to be executed ... are u sure of what ur telling me or are u guessing?

???

udendra

first of all , u don't need to add quotes (') to numeric/Integer values , so try doing away with them.

as for the date - u could manually calculate it using the PHP date() function and then pass the value to the query , or if its type date/time : MySql will by default add the current date and time to the record. (in that case u shouldn't add the time field in the INSERT query)

Weedpacket

Apparently (according to the suggestion in this thread), if you put the query on several lines, MySQL will tell you the line on which the error occurred. (Sounds reasonable to me - if MySQL ignored those linebreaks it wouldn't need to say "...on line 1" all the time.)