Can't figure out this database error

noimad1

Ok, i've connected to thousands of databases before and now I am running into a brick wall. Maybe I have been looking at the code too long or something, but can anyone see any problems with this code:

$dbh=mysql_connect ($servername, $dbusername, $dbpassword);
$db_selected = mysql_select_db($dbname, $dbh);
if (!$db_selected){
die (mysql_error());
if (!$dbname) error_msg(sql_error());
}

$sql = "INSERT INTO Order (CustomerID, OrderTotal, OrderDate, Magazine) VALUES ('$custom','$payment_amount','$payment_date','$item_name')"; 

$result = mysql_query($sql);  

if ($result == false){
echo mysql_errno().":".mysql_error()."<BR>";
exit;
}

I am getting the error:

1064: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 (CustomerID, OrderTotal, OrderDate, Magazine) VALUES ('te

all variables are just set = "test"

I'm sure it is something stupid that I am missing, but I can not figure it out...

tekky

my guess, you need to use Order since Order By is an SQL command

noimad1

Originally posted by tekky
my guess, you need to use Order since Order By is an SQL command

Crap, that was it. I could have looked at it for another 5 hours and still missed it. Sometimes it just takes that fresh pair of eyes to catch your mistakes.

It sucks because I am using someone elses database. I normally would use "Orders" for a table with orders in it....

Well thanks again for the help on that one.

tekky

No problem, glad it helped, and its never too late for an ALTER TABLE 😉