[PHP-DB] Any good way ?

[TV Karthick Kumar]

Hi all

    I have written the following code, but I dont' think it's a good way to
write like this. Is there some other way to do good programming for this ?!

****************************************************************************
******************
   if ($f)
   {
    $SQL .= " (FIRST_NAME like '%$f%') AND ";
   }
   if ($l)
   {
    $SQL .= " (LAST_NAME like '%$l%') AND ";
   }
   if ($em)
   {
    $SQL .= " (HOME_EMAIL1 like '%$em%') OR (HOME_EMAIL2 like '%$em%') OR
(WORK_EMAIL1 like '%$em%') OR (WORK_EMAIL2 like '%$em%') ";
   }
****************************************************************************
******************

    Any help is appreciated very much.

    Thanks in adv.

~ Karthick



-- 
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]