What is wrong with this query ?

[WarKirby]

Having an error with an insert query. Maybe this should go in the mysql forum, not certain

$result = mysql_query("INSERT INTO ".$dbSalesTable." (customerKey,customerName,articleNumber,productName,pricePaid,timeSold,vendorRegion) VALUES(".$customerKey.",".$customerName.",".$row[articleNumber].",'".getProductName($row[contentArticle])."','0',".$timeSold.",".$vendorRegion.")") or die(mail($to, "Error inserting content", mysql_error()));

 

the mail call is me emailing myself the mysql error, since this script is being run by another. It gives me an error for this line which reads:

 

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 'Test Product,'0',1262328364,'Ferox')' at line 1

 

Test Product being the productname. It seems that the problem is around there.

[trq]

You should save you query into a variable then echo it to see what it actually looks like. You may be missing some quotes.

[fareedreg]

$query= "INSERT INTO ".$dbSalesTable." (customerKey,customerName,articleNumber,productName,pricePaid,timeSold,vendorRegion) VALUES(".$customerKey.",".$customerName.",".$row[articleNumber].",'".getProductName($row[contentArticle])."','0',".$timeSold.",".$vendorRegion.");

 

$result = mysql_query($query,<database link>);

 

[WarKirby]

ah, solved now. Silly mistake of course. Where I used $row[articleNumber] that should have been $row[contentArticle]. The articlenumber column doesn't exist in the table it's querying, since that table stores pairs of two articles.