Posted by "Shaun" on 10/18/05 19:15

Hi,

Up to this point in time I used to construct my insert statements like this

$qid = mysql_query('INSERT INTO MYTABLE (
column1,
column2,
) VALUES (
"'.$value1.'",
"'.$value2.'"
)');

However I understand it is better to remove the quote marks around an insert
if the column type is an integer. This is easy to do, however if the $value
is empty it causes a mysql error. Has anyone encountered this and found a
solution?

Thanks for your advice

[Back to original message]