[SOLVED] PHP INSERT error...What???

[resdog]

Hello everyone. Had a bit of a stumper to me, maybe someone can help. I have a basic php site, with a MySQL database. The database has a table, "vendortrack", and the rows are "refnum ,order ,tracking ,shipcost ,dateshipped". I'm trying to do a simple INSERT INTO php command with posted variables, as follows:

 

$q = "INSERT INTO vendortrack (refnum, order, tracking, shipcost, dateshipped)
			VALUES ('$refnum','$order','$tracking','$shipcost','$todaysDate')";
$result = mysql_query($q)
	or die(mysql_error());

 

When I run this on the server, I get this error:

 

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 'order ,tracking ,shipcost ,dateshipped) VALUES ('ddf','2252','1Zkdikd','2.25' at line 1

 

I don't see what is wrong. So I went to PHP MyAdmin and ran a smiliar query to see what the SQL looked like. Everything was the same, except there are these weird kind of quotes around the rows:

 

`refnum` ,`order` ,`tracking` ,`shipcost` ,`dateshipped`

 

They aren't the apostrophe character, but I don't know what they are (apostrophe: '  that other character: `  . I replaced that line with the line from phpMyAdmin, and the script works great! I've never had to add the quote things before when I did INSERT INTO, I've just had to name the rows. Does anyone see what my problem is, or what those apostrophe looking characters are? Thanks in advance for your help!

[trq]

order is a special keyword in sql. Your confusing the mysql database. You can use `backticks` to escape special words in mysql, though its best (if possible) to chnage your field names.

[resdog]

THANK YOU! THANK YOU! THANK YOU!