how to check if a record does NOT exist in a table?

Greywacke · December 31st, 2009, 03:35 PM

hi, i'm trying to check wether an email address is in the blacklisted table.

here is the code i am using atm,

PHP Code:


			
        $consumerfullname        = $_POST["text_consumerfullname"];                                // rerequest consumer full name
        $consumeremail            = $_POST["text_consumeremail"];                                    // rerequest consumer email
        $tsql = "SELECT * FROM 7_blacklist WHERE `text_E-mailAddress` = ".$consumeremail.";\n";
        $sql .= $tsql;
        $result = mysql_query($tsql);
        $err = mysql_error();
        $sql .= strtoupper($err)."\n";
        if ($result) {
                echo "    <result>\n";
                echo "Your e-mail address has been blacklisted for inappropriate use of Ferrety.co.za by the administrators.\n\n".
                     "Please contact Jaap Venter at [email protected] for more information.";
                echo "    </result>\n";
        } else {
// do e-mail stuff
        }

unfortunately for some reason that logic does not dictate, a blacklisted e-mail address can STILL send requests 0o.
I sincerely doubt it has anything to do with the - (dash) in the column name, as that is the reason for the backfacing quotes around it (`escaped-column-name`).

Greywacke · December 31st, 2009, 04:14 PM

woops, forgot the double quotes around the inserted string :P

pity that didn't do a thing to the results :(

here follows the code i am trying to use now.

PHP Code:


			
        $tsql = "SELECT * FROM 7_blacklist WHERE `text_E-mailAddress` = \"".$consumeremail."\";\n";
        $sql .= $tsql;
        $result = mysql_query($tsql);
        $err = mysql_error();
        $sql .= strtoupper($err)."\n";
        if ($result) {
                     if (mysql_num_rows($result) <= 0) {
                                     echo "    <result>\n";
                                     echo "Your e-mail address has been blacklisted for inappropriate use of Ferrety.co.za by the administrators.\n\n".
                                                "Please contact Jaap Venter at [email protected] for more information.";
                                     echo "    </result>\n";
                     } else {
                                  // do mailer stuff
                    }
        }

it still alerts the error when you use a non-blacklisted address, and still sends the mails regardless.

Greywacke · January 1st, 2010, 04:14 AM

i've gotten it to work yay! don't be working when u'r tired hey!

lol

PHP Code:


			
        $tsql = "SELECT * FROM 7_blacklist WHERE `text_E-mailAddress` = \"".$consumeremail."\";\n";
        $sql .= $tsql;
        $result = mysql_query($tsql);
        $err = mysql_error();
        $sql .= strtoupper($err)."\n";
        if ($result) {
            if (mysql_num_rows($result) > 0) {
                // do blacklist alert stuff
            } else {
                // do mailer stuff
            }
        }