SELECT FROM db WHERE value!=$array

[George Botley]

Is it possible to achieve a similar thing to this...

 

SELECT FROM db WHERE value!=$array

 

My example code is this:

 

$browser_hide = array("1" => "YandexBot 0.0 for unknown");

$query = "SELECT * FROM hitlist_hits WHERE month='$month' AND browser!='$browser_hide' ORDER by id DESC";

 

Thanks Guys.

[George Botley]

Any ideas?

[Psycho]

Seriously, you waited a whole 12 minutes before bumping your thread. Perhaps the lack of responses is due to the lack of clarity in your request. I *assume* you are wanting to find records where the value does not exist in the values of the array.

 

The query would use the operator "NOT IN" followed by a list of values.

$values = "'" . implode("','", $browser_hide) . "'";
$query = "SELECT *
          FROM hitlist_hits
          WHERE month='$month'
            AND browser NOT IN ($values)
          ORDER by id DESC";

[George Botley]

Thank You, I will try that one..

 

 

Sorry for my impatience, the project is due shortly, and that was bugging the hell out of me!!

 

 

I will try to be more clear in future posts.

[George Botley]

Could you explain what this section does?

 

 

$values = "'" . implode("','", $browser_hide) . "'";

[Psycho]

Could you explain what this section does?

 

 

$values = "'" . implode("','", $browser_hide) . "'";

 

http://php.net/manual/en/function.implode.php

 

echo $values to the page to see what the result is.