Sql produces inexplicable error - php

Question

I have this php code to get the fields from a table

$id = $_GET['idd'];
$userip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
// do some validation here to ensure id is safe

$link = mysql_connect("localhost", "root", "");
mysql_select_db("veet");
//check if ip record is in DB
$sql_ip = "SELECT id FROM ip_address_list WHERE ip=$userip";
$result_ip = mysql_query("$sql_ip");

if (mysql_num_rows($result_ip) > 0) {
    echo "Ip is already in database";
    //
}
else { 
    echo "Ip is not in database";
    //put ip to database and vote
}

and the query returns an error so i get the "mysql_num_rows() expects parameter 1 to be resource". If i change the WHERE ip=$userip"; to WHERE id=$id"; it works. Do you have any idea what might be the problem with the column ip??

EDIT: Because of the repost thingi. i am not asking how to deal with a false return I am asking why it returns false response. The sql query looks 100% correct to me.

i feel like am in a small raft in an ocean and anywhere i look is just another wave. ie am lost. I have no clue why this doensnt work :P — hahaha, May 13 '14 at 11:51
You have to quote literal strings in most computer languages. SQL is not an exception. Just look at the accepted answer on the other question to learn how to read error messages yourself. — Álvaro González, May 13 '14 at 11:54
thank you. I came to the result that I am unimaginably stupid :) — hahaha, May 13 '14 at 11:55

Sql produces inexplicable error - php

0 Answers0