I think you may hit the limit on the number of characters in the SELECT statement before you hit the max number of WHERE items. It's a good question though. Try doing a worst case scenario (pick all the options, enter data that's the max character length for each item, etc). Either through your form or typing it all manually. The worst that'll happen is it'll say "Sorry.. Too many characters" or "Too many WHERE items" or something. Also, check the documentation for the database system you're using (MySQL or whatever) and see if it says anything under the WHERE clause or max length of SELECT statement. If you find anything interesting, let us know. Sorry couldn't give you a better answer. -TG > -----Original Message----- > From: Stuart Felenstein [mailto:stuart4m@xxxxxxxxx] > Sent: Wednesday, December 01, 2004 10:56 AM > To: php-db@xxxxxxxxxxxxx > Subject: RE: Question on the use of where statements > > > --- Bastien Koert <bastien_k@xxxxxxxxxxx> wrote: > > > so...best to build the statement dynamically and > > execute it once only if the > > input box has a value in it... > > > > And that is the way I'm building it. Just thinking > about the scenario that somone actually chooses 75% of > the options - would that potentially make a huge hit > on the system. > > Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
