Based on caste,religion,location,gender,age i need to filter data from my database,how shall i do it.
In mysql database i have religion,gender,,location,age as separate column in same table.
Code i have used
$result=mysql_query("SELECT * FROM enquiry where location like '%$text%' ") or die("error");
$found=mysql_num_rows($result);
if($found>0){
while($row=mysql_fetch_array($result)){
//display of data
}
Using this i can search data from one column using one keyword...as i am new please give me right way to slove this using php .