Check a whole database for something?

[lolwut]

When my users fill in this form on our site their IP gets put in the database along with the other data....
How could I make it check to see if their IP is already in the database?

EDIT: Atm I've got:

$check = mysql_query("SELECT `ip` FROM `entries` WHERE `ip` = '$ip' ;");

if(isset($check)){ die('You cannot enter more than once!'); } 

Any help appreciated.

[Luno1599]

ohhhhhh i know this :S but forgotten... Give me a min

Edited by opensourcehost (Forum Super Moderator): Please do not post pointlessly.

[Jamie.]

When my users fill in this form on our site their IP gets put in the database along with the other data....
How could I make it check to see if their IP is already in the database?

EDIT: Atm I've got:

$check = mysql_query("SELECT `ip` FROM `entries` WHERE `ip` = '$ip' ;");

if(isset($check)){ die('You cannot enter more than once!'); } 

Any help appreciated.

$fetch7 = mysql_query("SELECT `ip` FROM `entries` WHERE `ip` = '$ip'")
or die(mysql_error());  
    $fetch8 = mysql_num_rows($fetch7);
if ($fetch8 == 0) {
//the ip doesnt exist }
else {
//the ip exists 
} 

[QuickScriptz]

Try a php look:

PSEUDO CODE:

<?php
while($dbs = get_mysql_table_list('from_db');){
     //Do your check here
     if(entry = found){
          $found = 'yup';
     }
}
if($found == "yup"){
     //It exists!
}else{
     /Sorry, nothing...
}
?>

Note that is pseudo code - therefore it wont actually parse or work, it is just meant to explain the logic behing what I'm suggesting.

[Blob]

if( mysql_num_rows($sql) > 0 )
{
// Error
} else
{
// Stuff
} 

[Dentafrice,]

<?php
include "config.php"; // includes config file

$check_i = mysql_query("SELECT ip FROM entries WHERE ip='$ip'");
$check_n = mysql_num_rows($check_i);
if ($check_n == "" || $check_n == "0")
{
    echo "You cannot enter more then once!";
    exit;
}
?>

[Beau]

<?php
include "config.php"; // includes config file

$check_i = mysql_query("SELECT ip FROM entries WHERE ip='$ip'");
$check_n = mysql_num_rows($check_i);
if ($check_n == "" || $check_n == "0")
{
    echo "You cannot enter more then once!";
    exit;
}
?>

mysql_num_rows() returns an integar, and only an integar. There's no need to check for empty strings, or to treat the 0 like a string, by enclosing it with quotes.

[Dentafrice,]

It doesn't matter, thats the way I do it.

[Beau]

It doesn't matter, thats the way I do it.

Well, it's a waste of server resources, time, and most importantly, waste the energy your fingers have to go to typing it in

if(mysql_num_rows($query) > 0) {

     // Rows were returned

}

else {

     // No rows returned (0)

} 

That's all you need to do to check for rows returned

[Jamesy]

haha that's like the script you told me last night.

You are good!