Re: force no results

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

-----------------------------------------------------------------