[MySQL] Insert query error! - Overclock.net

LyokoHaCk · 02-10-08

Code:

mysql_query("INSERT INTO `table` ( `url` , `ip` ) VALUES('http://mysite.com' , '0.0.0.0')");

When I try to execute that query in php, I get

Quote:

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 '0.0.0.0')' at line 1

Using MySQL 4 (.2 or something)

Thanks!

e_dogg · 02-10-08

In your "insert into" statement, you shouldn't need the quotes around the table and column names. Try this:

INSERT INTO table ( url , ip ) VALUES('http://mysite.com' , '0.0.0.0')

Also, your table name really isn't called "table", right? If so, you should really change your database schema. If for some reason you do need your table called "table", enclose it in square brackets like this: [table].

Hope that helps!

Starholdest · 02-11-08

mysql_query("INSERT INTO `table` (`url`,`ip`) VALUES ('http://mysite.com','0.0.0.0')");

Works perfectly fine for me. I'm sure you have one of your table/row names messed up.

immoral giant · 02-11-08

Your code is fine. I imagine it is the database itself. Have you got the ip row set up as an integer? If so, I don't think it will work due to the .'s, change it to VARCHAR(15).

LyokoHaCk · 02-12-08

Took care of it. PHP didn't trim the url and it had backslashes at the beginning and end of the string. Thanks guys!

		Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Web Coding
[MySQL] Insert query error!

02-12-08	#5 (permalink)
LyokoHaCk Programmer Join Date: Aug 2006 Location: United States Inc. Posts: 1,964 Rep: 73 Unique Rep: 68 FAQs Submitted: 1 Trader Rating: 2	Took care of it. PHP didn't trim the url and it had backslashes at the beginning and end of the string. Thanks guys!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)