RE: [PHP-DB] multiple select statements

2002-03-05 Thread Shrock, Court
rse you may want to add checks on what was entered or build a mechanism so that you don't necessarily join all the filters with 'OR'. But, I think you get the idea. Hope it helps. Court > -Original Message- > From: Geoffrey Makstutis [mailto:[EMAIL PROTECTED]] >

[PHP-DB] multiple select statements

2002-03-05 Thread Geoffrey Makstutis
Hi, I've got an HTML form which allows users to select various criteria to search for in my database (MySQL). The problem is that I can't seem to figure out how create the SELECT statement, given the fact that they could choose any or none of the criteria. Does anyone know of a way to dynam