Have you tried using and ' NOT IN ' statement in your WHERE clause? There are many comparison operators that you might find useful. They are covered in 6.3.1.2 of the MySQL Manual, you may also follow this link : http://www.mysql.com/doc/C/o/Comparison_Operators.html.
If you can't solve this problem through comparison operators, you may need to check and see how you are identifying your data results. Possible table joins or maybe even a ' LIKE ' statements might help. I would have to have more information on your situation to really be of any help though gl -- Seth Martin Adler wrote: > Hi, > > is it possible to force mysql in a SELECT clause depend on a > condition to give no results? > > for example: > I do a SELECT and get 3 rows as result, > but one row contains a value, which make the > other rows worthless. and I won't get this results > > thank's > > sincerely > Martin > > ----------------------------------------------------------------- > Martin Adler CGI, Perl, PHP > > Continum AG Tel. +49 761 4794090 > Bötzinger Straße 29a Fax. +49 761 4794099 > 79111 Freiburg i. Br. http://www.continum.net > ----------------------------------------------------------------- > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php