RE: [PHP-DB] Question on the use of where statements
| From: | Bastien Koert | Date: | Wed, 01 Dec 2004 15:46:26 +0000 |
| Subject: | RE: [PHP-DB] Question on the use of where statements | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37499@lists.php.net to get a copy of this message | ||
so...best to build the statement dynamically and execute it once only if the input box has a value in it...
$sql = "select * from table where 1 ";
if (isset($_POST['field1'])){ $sql .= " and column1 = '".$_POST['field1']. "'";
...
if (isset($_POST['fieldN'])){ $sql .= " and columnN = '".$_POST['fieldN']. "'";
$result = mysql_query($sql);
...
bastien
From: Stuart Felenstein <stuart4m@yahoo.com> To: php-db@lists.php.net Subject: [PHP-DB] Question on the use of where statements Date: Wed, 1 Dec 2004 07:28:24 -0800 (PST) I posted this over on mysql list. Not trying to be redundant, but would like to get some feedback. Basically I'm wondering. I am creating a search form , dynamic query, that could potentially have in the area of 40+ where statements. i.3. 1- where x = y and -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php