php mysql query syntax error

[hwoarang69]

this works fine

$view_query = mysql_query("SELECT ip_address FROM view");

but this query below give me a error

$view_query = mysql_query("SELECT ip_address FROM view WHERE ip_address = $user_ip") 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 '.0.1' at line 1

only reason it give my error bc of 'WHERE ...'. it looks good to me. i also connect to the database at to of page. mysql_connect...

[jkon]

Propably the ‘ip_address’ in your ‘view’ table is VARCHAR so you need to use quotes ( '$user_ip' ) . Besides that I would really recommend you to take the time to learn how to use prepared statements … PHP has the PDO data access interface which is great , really simple and the time that you will spent learning how to use it will pay off.

[hwoarang69]

thanks, got it to working and yea i going to start using pdo now.

[james.anthoney.716]

Hi,
I have some sites like Business Ideas , instalhost , Bag Store , Fizba , New music Vidoe etc.... I had faced that priblem for all my sites. I have solved that issue after following your tips. Thank you so much.