Search Engine Help

[bigdaddysheikh]

Hello,

I want to make a search engine for my site. I have tried using the lke command in mysql but it has given me no results even though I know I should be getting results.
The code below is what i am using and is not working.

$search=mysql_query("Select * from link where Description Like '$kword'");  					$rows=mysql_num_rows($search);

I would like to make a search engine which will query the field 'Description' in the table 'link'. I have been reading some post about indexing mysql, but i do not even know what indexing is in mysql. Any help would be greatly appreciated. I do not know how to go about making a good search engine for my website.

Thank you for your time.

[Sgarissta]

Originally posted by bigdaddysheikh

$search=mysql_query("Select * from link where Description Like '$kword'");  					$rows=mysql_num_rows($search);

Try this

$search=mysql_query("Select * from link where Description Like '%$kword%'");  					$rows=mysql_num_rows($search);

[bigdaddysheikh]

Thank you bery much for the code. I greatly appreciated. I am getting more and better results.

Thank you