Well, I have a code that just won't run. It says it has a syntax error, but I've been looking at this code for 20 minutes and haven't found any. Could you guys plese tell me if something is wrong?
// $anio holds the name of my table.
$query="INSERT INTO $anio
(nombre, RFC, factura, importe, IVA, total)
VALUES
('$nombre', '$RFC', '$factura', $importe, $IVA, $total)";
//This echo returns my query, wich seems perfect to me.
echo $query;
//This is the part that displays an error. I'll show it to you in a moment.
mysql_query($query) or die("Operation could not be performed: " . mysql_error() );
And this is what I get when I run the script:
//this is the $query that i echoed a little bit ago:
INSERT INTO 2012 (nombre, RFC, factura, importe, IVA, total)
VALUES ('Prueba', 'RFCprueba', '25487', 100.4, 16.064, 116.464)
//this is the mysql_error():
Operation could not be performed: 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 '2012 (nombre, RFC, factura, importe, IVA, total) VALUES ('Prueba', ' at line 1
the values inserted are just test values.
Sorry to make a threadn on such a silly matter, but I'm lost. I realli think this should work.
