ip ban

[chriscloyd]

heres my php script for checking for bans

[code]<?php
//checkbans
include("db.php");
$ip = $_SERVER['REMOTE_ADDR'];
$cip = mysql_query("SELECT * FROM bans WHERE ip = $ip");
if ($cip) {
$reason = $checkip['reason'];
header("Location : banned.php?reason=".$reason."");
}
?>[/code]

and i have this running off my localhost so i put ip 127.0.0.1 in the database but it wont send me to the banned.php page

[fert]

is't because your viewing it in a web browser and when you do that it send your IP address and not 127.0.0.1

[Psycho]

echo $ip to the page and add that ip to the database.

[chriscloyd]

i have done both ip addess my 68.104.210.230 and that one
and when i did echo $ip it shows 127.0.0.1

[chriscloyd]

i changed my code to
[CODE]
<?php
//checkbans
include("db.php");
$ip = $_SERVER['REMOTE_ADDR'];
$cip = mysql_query("SELECT * FROM bans WHERE ip = $ip") or die(mysql_error());
if ($cip) {
$reason = $checkip['reason'];
header("Location: banned.php?reason=".$reason."");
}
?>
[/CODE]

and now i get the 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

[chriscloyd]

i got it to work
i just didnt do '$ip' on the mysql_query