PHP: INSERT Into Database Using MySQL

Question

I'm running this on my website:

$PlaceOrder = " Insert INTO Order VALUES ( '$CustomerID' , '$ItemID' , '$Quantity' , '$Date' ) ";   
    $result = mysql_query ($PlaceOrder);
    if (!$result)
    {
        die('Invalid query: ' . mysql_error());
    }

But when I ever I do I keep getting the following error message:

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 'Order VALUES ( '3' , '1' , '12' , '11/05/2013' )' at line 1

I really have no idea what to do now, I tried specifying the columns but that didn't work either. I am very new to this whole thing and I'm executing this based on whats in the manual.

I need to ask; is this your actual code `Insert INTO Table VALUES` ? Are you using `Table` as your table name? — Funk Forty Niner, Nov 06 '13 at 03:24
What is the table structure? If your date column is a date it should be 2013-11-05 — Tim Holum, Nov 06 '13 at 03:26

score 2 · Accepted Answer · answered Nov 06 '13 at 03:24

2

Let's look at your error message again:

[...] the right syntax to use near'OrderVALUES

The first thing it complains about is Order. That's what you substitute the Table from your question for. So let's assume that's your actual table name.

It's also a reserved word. Enclose reserved words in backticks when used as column or table name identifiers.

answered Nov 06 '13 at 03:24

mario

144,265
20
237
291

Haha didn't I didn't that was a reserved word. I put a '.' before 'Order' and that did the trick! – bloodstorm17 Nov 06 '13 at 03:30

score 0 · Answer 2 · answered Nov 06 '13 at 03:25

0

Order is Key word Just use another word instead of Order

answered Nov 06 '13 at 03:25

user2889058

135
4
14

Actually the OP doesn't have to use another word, just wrap it with backticks. – Funk Forty Niner Nov 06 '13 at 03:33

fos.alex · Answer 3 · 2013-11-06T03:33:14.317

0

First of all, you should always specify the columns since you never know when you will have to add new columns to the table and old queries will start doing messy things if you haven't done that.

Having said that, are you sure those are the correct column data types that match the table's? Also, make sure the date format is valid, you shoud use Y-m-d. You will find more info here.

edited Nov 06 '13 at 03:33

answered Nov 06 '13 at 03:25

fos.alex

5,317
4
16
18

score 0 · Answer 4 · answered Nov 06 '13 at 03:26

Are you sure there are only 4 columns and are they in the same order as you have specified in your query?

As you suggested try to add the column names, for example:

$PlaceOrder = "INSERT INTO Table (customer, item, quantity, date) VALUES ('$CustomerID', '$ItemID', '$Quantity', '$Date')";

Does this help you?

PHP: INSERT Into Database Using MySQL

4 Answers4