Hello.
I have a table in a databse that holds html tutorials. Each row has a collum called "related" which holds a list of "key words" that describe the partucular tutorial. values in the "related" feild are sepperated by commas. I'm writing a search engine to search that feild. Below is the code i use to search the table:
$query="SELECT id, title, abstract FROM $table WHERE related LIKE '%$search%'";
($search being the search the user typed in)
The problem comes in when the user tries to type in more than 1 word to the search engine. It dosen't come up with any results. Any ideas?
Thanks in advance.
I have a table in a databse that holds html tutorials. Each row has a collum called "related" which holds a list of "key words" that describe the partucular tutorial. values in the "related" feild are sepperated by commas. I'm writing a search engine to search that feild. Below is the code i use to search the table:
$query="SELECT id, title, abstract FROM $table WHERE related LIKE '%$search%'";
($search being the search the user typed in)
The problem comes in when the user tries to type in more than 1 word to the search engine. It dosen't come up with any results. Any ideas?
Thanks in advance.