problem realted to database please

[nitika anand]

how to search from the database when we have multiple textbox and condition is that user can search from any of the textbox

//$akp=mysql_query("select * from enquiry where name='".$_REQUEST['name']."'or  id='".$_REQUEST['id']."' or  email='".$_REQUEST['email']."'or  mobile='".$_REQUEST['mobile']."' " );//(its not wroking)

[Luuk]

I think you should build your sql-statment like this:

$sql = "select * from enquiry where "
if $_REQUEST['name']<>"" then $sql .= " or name='".$_REQUEST['name']."' ";
if $_REQUEST['id']<>"" then $sql .= " or  id='".$_REQUEST['id']."';
....
$akp=mysql_query($sql);
 

and finally about "(its not wroking)"
please, next time, tell here why you think "its not working".....
don't let the reade guess about why you think it does not work....