thanks .. but my question is not for isset... i m thinking consider that i have 10 search fields... if i have to do a combination then i need a day to right the various SQL statements "David Robley" <robleyd@xxxxxxxxxxxxxx> wrote in message news:20040526113904.54450.qmail@xxxxxxxxxxxxxxx > Nabil wrote: > > > hi all.... > > > > Is there a way to condition your search: > > > > -I have a form for four text boxes for search my Mysql... > > -I don't want to write 4 conditions and for SQL statements incase he > > decided not to search with all keywords (fields) > > - I have by example : name, lastname , nickname and phone form... > > I need a way to select my records even one or more field were null > > (searching only on of the above) > > > > because the following SQL will generate null result > > > > > > $name=$_POST['naame']; > > $lastname=$_POST['lastname']; > > $nickname=$_POST['nickname']; > > $m_date=$_POST['m_dateY']; > > echo $name.$lastname.$nickname.$m_date; > > > > $sql = mysql_query("SELECT id, name , lastname , m_date from users where > > name like binary '%$name%' and lastname like binary '%$lastname%' and > > nickname like binary '%$nickname%' and m_date= YEAR('$m_date') order by > > id ASC ") or die(mysql_error()); > > > > > > > > Thanks in advanced > > Use isset to test whether the POST values are set and only include in the > query if there is a value. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
