Dear I am facing some problem with search string.
I have suppose three fields to enter search query
1. Firstname
2. Lastname
3. Email

I used this statement to search database;
select * from `cs_profile` WHERE firstname='"$_POST['firstname']."%' AND lastname='".$_POST['lastname']."%' AND email='".$_Post['email']."'"
Query is successful.

But, when any one search giving only firstname, remaining lastname and email blank I don't get result that people who signed up filling every fields.

I can understand the problem is when user seach only giving firstname and remaining other fields blank, database also search keeping these columns blank though these columns are not blank.

My Desire:
If anyone give only firstname i want to create querystring
"SELECT * FROM `cs_profile` WHERE firstname='".$_POST['firstname']."'"
if anyone give only lastname i want to create querystring
"SELECT * FROM `cs_profile` WHERE firstname='".$_POST['firstname']."'"


I can manually solve it. But when there are many fields then what I should do.

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net

__________________
Best Regard:
Md. Zakir Hossain (Raju)

www.rajuru.xenexbd.com - my blog with PHP scripts, PHP Book Review and many more

Try this:

$sql = "select * from `cs_profile` WHERE ";

if (!empty($_POST['firstname'])) {
$sql .= "firstname='" . $_POST['firstname'] . "%'";
}
(repeating for the other variables)

You'd need to do some checking of the number of variables passed to determine wether you need an "AND" between the two SQL conditional statements.

Many shoes,

James

Dear James
thank for reply,

but before your reply i tried this code:

$sstring="";
if(!empty($_POST['firstname'])) $sstring ="firstname LIKE '%" .$_POST['firstname'] ."%' OR ";
if(!empty($_POST['lastname'])) $sstring .="lastname LIKE '%".$_POST['lastname']."%' OR ";
if(!empty($_POST['nickname'])) $sstring .="nick LIKE '%".$_POST['nickname']."%' OR ";
if(!empty($_POST['district'])) $sstring .="district LIKE '".$_POST['district']."' OR ";
if(!empty($_POST['************'])) $sstring .="************ LIKE'" . $_POST['************']."' OR ";
if(!empty($_POST['dept'])) $sstring .="dept LIKE '" .$_POST['dept']."' OR ";
if(!empty($_POST['session'])) $sstring .="session LIKE '" .$_POST['session']."' OR ";
if(!empty($_POST['yearofpass'])) $sstring .="yearofpass LIKE '" .$_POST['yearofpass']."'";

$sstring=rtrim($sstring," OR");

and it is working very nice

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net