Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

[Victor Foitzik]

Hello JD,
on 19.04.2001 you wrote:

>                  if (!empty($Price))
>                  {
>                         if(empty($whereclause))
>                          {
>                                  $whereclause.="Price$Price";
>                          }
>                          else
>                          {
>                                 $whereclause.=" AND 'Price $Price";
>                         }
>                  }

and even better would be:

if (!empty($$varname)) {
   $whereclause .= ($whereclause ? ' AND ' : '').
                "$varname =" . $$varname;
}

or something like this ;-)

HTH
Vic



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]