Welcome to WebmasterWorld Guest from 54.159.12.17

Forum Moderators: open

Message Too Old, No Replies

search from database using two or more different keywords

using php search database by two or more keywords...

     

anya

11:05 am on Oct 29, 2013 (gmt 0)



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 .
 

Featured Threads

Hot Threads This Week

Hot Threads This Month