Jump to content

[SOLVED] mysql insert, slash (/) in column name


SchweppesAle

Recommended Posts

hi, not really sure if it's the slash which is causing this(IP/UA).  The following code is returning an error message though.

 

$new = "INSERT INTO jos_keyword_filter (IP/UA) VALUES('$addFilter')";
		$result = mysql_query($new) or die(mysql_error());

 

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 '/UA) VALUES('test')' at line 1

 

so far I've tried adding single quotes on either side of the attribute [  keyword_filter ('IP/UA') ]  seems to be giving me the same prob though.  I'm sure it's probably something that should be obvious  :wtf:

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.