ip checking

[sebastienp]

Hey guys,

this is what im having a problem on :

http://www.pastebin.com/53314

i dont know what condition exactly to put in the if statement. Heres what id like to do, for each message that gets posted, i store the IP along with the TEXT and TITLE in my database called Content.

After i do the SELECT, if it doesnt find an ip thats identical to the one trying to post, then it puts the message in the Content Table, else it would put the message in the Spam Table.

thanks
-seb

[LordShryku]

Well, I'd just count. You need to fetch it also. Like this:

$sql = mysql_query("SELECT count(*) FROM Content WHERE ip='".$ip."'");	
$row = mysql_fetch_row($sql);
if($row[0] > 0) {
   mysql_query("INSERT INTO Spam....");
}
else {
   mysql_query("INSERT INTO Content....");
}

[sebastienp]

thanks a bunch LordShryku 🙂