implement a search functionality

[smgeshi]

Hi all,

I want to develop a search functionality in my php website. My requirement is as below..

I have a text field for entering the required key word.After enter my search keyword and hit the "search" button, it should list all the data with respect to the entered item.

Eg:If i enter the word "hospital" in the text field and hit search button, then it should list the names of all hospitals in that country..
How can I implement it..

Thanks in advance
AlAyam

[pritaeas]

What do you have so far?

[Webville312]

Try this tutorial.

[Webville312]

If that is not what you want to implement, then try creating yours, and then let us know where you get stuck ...

[OsaMasw]

THIS is the simple way to search and you can develope it

<?php
$word = $_POST['NAME_OF_TEXTBOX']; // dont forget to protect those inputs
$sql = "SELECT * FROM YOUR_DATABASE WHERE YOUR_COLOUMN LIKE '%".$word."%' LIMIT ANY_NUMBER";
$run = mysql_query($sql);
if (mysql_num_rows($run) > 0 ) {
while ($data = mysql_fetch_assoc($run)) {
echo $data['YOUR_COLOUMN'];
}
}else {
echo "No result";
}
?>