going slightly mad...

[flatpooks]

i have a db that ive been using for a site im developing and everything is cool bananas except today an insert stopped working for no apparent reason

its a real simple statement that if i echo to a window and run thru the mysqladmin cmd line tool works but in my code it doesnt (as of this morning) ... i get "there is an error in ur sql statement blah blah" which there isnt actually

the permissions are good cos the rest of the site works fine

anybody seen anything like this before?

thnx

[drawmack]

we may be able to help you if you posted the echoed query, the php and the full text of the error.

[flatpooks]

sorry...

insert into user_store (user_id,store_id,status,cdate,qty,price) values (2,4,'P',now(),1,'12.99')

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

everything is as it should be in the db ... it was working up to last night far as i can tell

thnx

[drawmack]

is price a float field? It may be those single quotes.

[flatpooks]

no sorry ... its a decimal
i didnt have the quotes on it b4 but i read somewhere that they are stored as strings so i figured id try it ... made no difference at all