simple search query

[newsamsu]

:'( hi there,

im just wondering if anyone can help me with creating a simple search using php. i have a table in mysql and want to be able to search  using the name of the person that is in the table.

can anyone help me with the code of how to create such a thing.

 

thank you

[p2grace]

You'd use like statements in the query.

 

<?php
$search_str = "bob";

$query = "SELECT `name` FROM `users` WHERE LOWER(`name`) LIKE LOWER('%$search_str%')";
$run = mysql_query($query);
if($run){
   while($arr = mysql_fetch_assoc($run)){
      extract($arr);
      echo "name = $name<br />";
   }
}
else{
   die("Unable to connect to database.");
}
?>

 

This is obviously a very simple example, but it's enough to get you started.