A PHP script to search data within a table

[guarriman]

Hi.

I've got a table with (e.g.) ID, first name, last name, address, city, etc.

I want to develop a PHP search script in order to find any text within one of these fields, but I suppose there could be one on the WWW.

Do you know one? Thank you very much.

[barns101]

Take a look into PHP's MySQL functions [php.net] and also the WebmasterWorld library [webmasterworld.com] and you should find what you need.

[FiRe]

$query = mysql_query("SELECT * FROM table WHERE first_name LIKE '%$name%' OR address LIKE '%$address%' OR city LIKE '%$city%'");
while($r = mysql_fetch_array($query)) {
echo $r['address']; //or whatever
}