I'm not sure what IF(value <> '', does however I got errors from it.
I also had to change $isbot_ipaddy to $isbot_ip
I then had to change $isbot_ip to '$isbot_ip' , otherwise it would return an error splitting up the IP address.
------
So I ended up with this and it works fine... Thanks!
$db->query_write("UPDATE setting SET value = CONCAT(value, ' ', '$isbot_ip') WHERE varname ='banip'");
|