MySQL syntax error driving me crazy

[dyluck]

Hi everyone:

 

I have this error that is driving me nuts and after scowering google for a long time, I can't seem to get my answer.

 

I have an array feeding a mysql query:

$insert = "INSERT INTO AUTOPRODUCT (".implode(", ",$parsecolmns).") VALUES (".implode(",",$parsevals).")";
mysql_query($insert) or die(mysql_error());

 

One of the array values is throwing the the following error:

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 '://www.' at line 1

 

Can anyone help me get this going?  Seems as though its accepting the other values except this one.  Is there a reason It won't insert a URL with this array?

 

Thanks in advance

 

[cags]

Change your code to...

 

mysql_query($insert) or die("SQL: $insert, ERROR: " . mysql_error());
// or even better
mysql_query($insert) or trigger_error("SQL: $insert, ERROR: " . mysql_error(), E_USER_ERROR);

... and show us the error message that is output. We have know way of knowing currently what your query actually looks like. It's most like a character that is not escaped properly.

 

[dyluck]

Thanks for your help.  Turns out it was because first i needed to escape the string then i had to quote (') over each of the implode entries like below.

 

$insert = "INSERT INTO AUTOPRODUCT (".implode(", ",$parsecolmns).") VALUES ('".implode("','",$parsevals)."')";mysql_query($insert) or die(mysql_error());

 

thanks so much!