Mysql Query to select * except for 1.

[duckxtales]

I have the following code and I'm having trouble doing a query where it looks up the DB to see if the email exsist, but it should bypass a specific email. Is there an except syntax where I can use to do a query to select * where email = $email except where email = 'xxx@xx.com'; ?

 

$results = $aQuery -> query("SELECT * FROM affiliates WHERE email = '$Email'");

$duplicatex = mysql_num_rows($results);

$duplicatexArray = mysql_fetch_array($results);

$atsign = substr_count($Email, '@');

 

if($duplicatex > 1) die("ERROR, MORE THAN 1 EMAIL HAS BEEN DETECTED. PLEASE REPORT TO ADMIN.");

[r-it]

select * from table where email <> '$email'

[ToonMariner]

As you set the value of $email that goes into the query then simply do not set it to the email you wish to be ignored by the query. If this is a user entering an email address to check if its listed then

 

$results = $aQuery -> query("SELECT * FROM affiliates WHERE email = '$Email' AND email != 'xx@xx.xom'");

 

Will ensure that no results are returned...

 

Or you could save yourself a query and do this..

 

if (strcasecmp('xx@xx.com', $email) == 0)
{
echo "NO RESULTS";
}
else
{
$results = $aQuery -> query("SELECT * FROM affiliates WHERE email = '$Email'");
$duplicatex = mysql_num_rows($results);
$duplicatexArray = mysql_fetch_array($results);
$atsign = substr_count($Email, '@');

if($duplicatex > 1) die("ERROR, MORE THAN 1 EMAIL HAS BEEN DETECTED. PLEASE REPORT TO ADMIN.");
}

[r-it]

my bad, i forgot the syntax for not equal in mysql is != and not <>, but its the same principle

[itsmeArry]

SELECT * FROM affiliates WHERE email = '$Email' and email <> "xx@xx.com"

[itsmeArry]

both will work either you use != or <> in mysql