mysql syntax error inserting decimal, timestamp with php -


I get an error:

There is an error in your SQL syntax; '10', '16: 39: 02 ',' 292.35 ') For the correct syntax to use on line 1, check the manual related to your MySQL server edition

The query that is running in PHP:

  mysql_query ("` copper '(`month`,` time`, `value`) Enter the value (' $ month ',' $ time ' , '$ Value')) or die (mysql_error ());  

Here is a verbal example:

  `table` (` month`, INSERT value ('10', '16: 39: 02 ',' 292.35 ')  

This is my table setup

 Alt text

It should work with the post, so here are some wild estimates :

Are you sure there is no ' in $ month ?

Are you sure you are actually The exact type of quote is that? The foreign stuff that comes out of the word processor these days? (Did you copy and paste it from the web and PDF / Doctor?)

Otherwise, query in Newlines Lose, no matter what, but you never know.


Comments