strange error

Inkybro

OK, well I have this line of PHP:

mysql_query("insert into stores (id,name,description) values('".$maximum."','".$name."','".$desc."'");

So, I get the mysql error:
You have an error in your SQL syntax near '' at line 1
(that is two 's not a ")

So I though one of the variables must be empty for some reason or another. But they aren't. I tried echoing them and they were all displayed. So either there's an error in my syntax or something or there is a bug in PHP.

hkucsis

Have you checked the data type of the fields? If they are numerical values, you don't need '

say if "id" is of integer type, your query should be

mysql_query("insert into stores (id,name,description) values(".$maximum.",'".$name."','".$desc."'");

// less the '

cgraz

youre not using mysql_error(), how did you get that error to print? I ask becuase i've seen people do this before:

$query = mysql_query("INSERT INTO. . .");

$result = mysql_query($query);

notice two calls to mysql_query(), the first one is correct, but the 2nd one tries to query a mysql_query(), not a string.

Also, one of those variables may have an unescaped character such as a single or double quote. If you don't have magic quotes set to on, make sure to run addslashes() on your variables.

Anyways, if there is more to your code, please post.

Cgraz

dombey

try this instead:
insert into table_name (first, second, third) values ('$first', '$second', '$third')
the concatonation is not necesary I believe

cdbsi

sometimes a field is set to NOT NULL and a value entered is null or not of the same type. (i.e. INT field with a STRING value being inserted)

try this:

echo "insert into stores (id,name,description) values('$maximum','$name','$desc'";

then post what is echoed here.