Search help needed

[wittanthony]

I'm trying to add a search feature on my site but I'm having problems. Some records in the database are not coming up when they should on some searches. Can some one help me write the code for doing searches in mysql database and displaying the results on screen? Is there also a way to get words in database to not be case senstive so that they show up when being searched for?

Thanks.

[bubblenut]

That's all very possible, what do you have so far (in terms of code)?

[wittanthony]

for the form part

<form method=post action=index.php>
<input type=text name=searchword>
<input type=hidden name=action value=search>
<input type=submit value=submit>
</form>

for the php part
$action = $GET['action'];
$searchword = $GET['searchword'];

if ($action == "search") {
$result = mysql_query("SELECT count() FROM files WHERE name LIKE '$searchword' ",$db);
$count = mysql_result($result,0);
$result = mysql_query("SELECT FROM files WHERE name LIKE '$searchword' ",$db);
}

[dnast]

You need wildcards (%):

name LIKE '$searchword'

should be

name LIKE '%$searchword%'

[wittanthony]

Thanks it worked.