<div>
@TheFoot<br />
<br />
I need to go disable your internet connection so I can get a chance to answer the questions. :)
</div>


@TheFoot

I need to go disable your internet connection so I can get a chance to answer the questions. :)

<div>
:) &nbsp;Gotta try and catch you guys up eh?
</div>


<div>
hi, another way is<br />
&nbsp;WHERE not fieldname IN (ListOfValues) <br />

</div>


hi, another way is
 WHERE not fieldname IN (ListOfValues)


<div>
<br />
<br />
WHERE * from Table Where FieldName Not IN (ListOfValues)
</div>




WHERE * from Table Where FieldName Not IN (ListOfValues)

<div>
Thank you very much. Exactly what i needed. Sorry i didn't reply sooner. I thought i would post and leave over night. Guess i didn't need to wait all that long.
</div>


Thank you very much. Exactly what i needed. Sorry i didn't reply sooner. I thought i would post and leave over night. Guess i didn't need to wait all that long.

<div>
Glad to help.. thanks for the points..
</div>


<div>
<div class="content wysiwyg-content">
i need to do a select where a particular field is not equal to any of the values in the array. so for instance my array has<br />
<br />
133007 <br />
133005<br />
133090<br />
<br />
mysql_query(&quot;SELECT partnumber FROM table WHERE ordernumber != arrayvalues&quot;)<br />
<br />
The issue is the amount in the values can change and potentially be 20/30 values.
</div>
</div>


i need to do a select where a particular field is not equal to any of the values in the array. so for instance my array has

133007 
133005
133090

mysql_query("SELECT partnumber FROM table WHERE ordernumber != arrayvalues")

The issue is the amount in the values can change and potentially be 20/30 values.

Mysql select where not euqal to array values

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.