note 96680 deleted from function.mysql-query by danbrown
| From: | danbrown@php.net | Date: | Thu, 11 Mar 2010 13:41:08 +0000 |
| Subject: | note 96680 deleted from function.mysql-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-166904@lists.php.net to get a copy of this message | ||
Note Submitter: Dionysios
----
Sorry for this but i really cant see what is wrong with it...
This piece of code :
$insquery=mysql_query("INSERT INTO temp (PARTNO, DESCRIPTIO, LISTPR, WEIGHT, QUANTITY,
REPLCODE, CODE3, CODE2, BRAND, PL_YEAR)
VALUES ('$tmppart', '$tmpdesc', $tmplist, $kgs, $quantity,
'$tmprepl', '$tmpcode3', '$tmpcode2', '$tmpbrand',
'$tmppl')");
Produces the following error
Invalid query: 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 ' 5.7531, 2, 'R', '',
'', 'CAT', '2010A')' at line 2
Checked the variables and they are ok. Mind you some of them are null.
Any ideas?