Use "SELECT COUNT(*) FROM tblURL WHERE IP = '192.168.1.1'". It will ALWAY return 1 row and 1 column where the count is.
via mysql command prompt:
mysql> SELECT COUNT(*) FROM tblURL WHERE IP = '192.168.1.1';
+----------+
| COUNT(*) |
+----------+
| 9 |
+----------+
If there is 9 rows where IP is '192.168.1.1'. If there is 0 (zero) result will be.
mysql> SELECT COUNT(*) FROM tblURL WHERE IP = '80.66.44.22';
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
mysql_query(conn,"SELECT COUNT(*) FROM tblURL WHERE IP = '192.168.1.1'");
res_set = mysql_store_result(conn);
my_ulonglong numrows = mysql_num_rows(res_set);
if (numrows > 0)
{
row = mysql_fetch_row(res_set));
printf("Count is: %s\n",row[0]);
}