Variable Order

kamy99

Hi all:

I have a question regarding data insertion into DB and the order of variable. 🙂

I'm using a code like this to insert data:

$sql = mysql_query("INSERT INTO Products (ProductID, ProductName, ProductPrice,ProdDesc) VALUES (NULL, $Name,$Price,$Desc);

...
The code works fine and everything does go through.

However the problem occurs when I change the order of fields in the form.
For example as long as name, price, description appear on the form in that order things are perfect, but when I move one nothing works.

Any suggestions?

Also, if I recall correctly, there is another method to insert data, in pairs,like this :

$sql = mysql_query("INSERT INTO Products ProductID(NULL), ProductName($ProductName) .........

Is this correct? What's the right syntax?

Thanx in advance.

Kamy

bernouli

$sql = mysql_query("INSERT INTO Products (ProductID, ProductName, ProductPrice,ProdDesc) VALUES (NULL, $Name,$Price,$Desc);

$sql = mysql_query("INSERT INTO Products (ProductID, ProductName, ProductPrice,ProdDesc) VALUES (NULL, ``,$Price,$Desc);

$sql = mysql_query("INSERT INTO Products (ProductID, ProductName, ProductPrice,ProdDesc) VALUES (NULL, $Name,``,$Desc);

or $sql = mysql_query("INSERT INTO Products (ProductID, ProductName, ProductPrice,ProdDesc) VALUES (NULL, $Name,$Price,``);

devinemke

i always insert into the database using "SET":

$sql = mysql_query ("INSERT INTO Products SET ProductID = $Id, ProductName = $Name, ProductPrice = $Price, ProdDesc = $Desc");

this way the order does not matter.

kamy99

That's what i'm looking for (SET), 🙂
But, when I tried, it didn't work.........

I even typed in the following through phpmyadmin => sql, but keep getting a syntax error, which I don't see:

INSERT INTO 'Products' SET ProductID='NULL', ProductName='test';

Help......

devinemke

take the single quotes off of NULL, it should be:
INSERT INTO Products SET ProductID=NULL, ProductName='test';