Unknown column in field list PHP MySql

Question

Trying to perform this query:

$result = "INSERT INTO `user`(`username`, `ip`, `country`) VALUES ('$username','$location[ip]','$location[country]')";

@mysql_query($result) or die("Error:". mysql_error());

Tried ever combination of single and double quotes, but constantly getting error:

Error:Unknown column 'ip' in 'field list'

Column 'ip' does exist in database, when I echo out query and run it in PHPMyAdmin it works perfectly

INSERT INTO `user`(`username`, `ip`, `country`) VALUES ('name32','127.0.0.1','mycountry')

Print out the sql the is being generated, that will give you an idea if your query is correct. — WayneC
– WayneC, Commented Jul 5, 2013 at 11:44
What if you do mysql_query("INTO user(username, ip, country) VALUES ('name32','127.0.0.1','mycountry')") or die(mysql_error() ); does that work? — Martijn
– Martijn, Commented Jul 5, 2013 at 11:49

Jahanzeb · Accepted Answer · 2013-07-05 11:43:27Z

1

Change your SQL query like this

$result = "INSERT INTO `user` (`username`, `ip`, `country`) VALUES ('".$username."','".$location['ip']."','".$location['country']."')";

answered Jul 5, 2013 at 11:43

Jahanzeb

6134 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jahanzeb Over a year ago

@user2411147 Try this. Is that work

@mysql_query("INSERT INTO user (username, ip, country) VALUES ('name32','127.0.0.1','mycountry')") or die("Error:". mysql_error());

Or you still get the same error??

Yogesh Suthar · Accepted Answer · 2013-07-05 11:46:25Z

1

im thinking that you might have made a typo in the database? I use IP every once in a while and im never having any problems. Could it be you named the column IP (uppercased)? That might break things

To make sure the name is correct, you could change the name to 'something' and change the query. If it starts working, its something in the names-area, otherwise you know for sure its not that

edited Jul 5, 2013 at 11:46

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

answered Jul 5, 2013 at 11:42

Martijn

16.2k4 gold badges39 silver badges73 bronze badges

3 Comments

snajperist Over a year ago

When I swap 'ip' with 'country', than country makes an error. I don't understand why echoing result out and manually running query makes no error

nickle Over a year ago

check database connections once

snajperist Over a year ago

Yep, different DB was selected, containing same table but different columns. Such a stupid mistake. Thanks.

Collectives™ on Stack Overflow

Unknown column in field list PHP MySql

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related