[SOS]a search for a database ,double click here

webtuto · 01-06-2008, 09:37 PM

hi ,
well im trying to do a search form for my database here is the code =>

PHP Code:


			
<?php



if(!empty($_POST['search']) ) {

$con = mysql_connect("localhost","root","") ;

$db = mysql_select_db("test") ;

$sql = "select * from webt where name='%$_POST[search]%' ";

$res = mysql_query($sql) ;

if (mysql_num_rows($res) == 0 ) {

          echo "No result";

 }else{ while ($row = mysql_fetch_array($res) ) {

       

      echo $row[name]."<br><br>" ; 

       }

       

}

}else{ echo"full the form"; } 



?>

<form method="post" action="search.php" >

<b>Search</b><input type="text" name="search" >

<input type="submit" value="Search" >

</form>

and in the database there is name='aa'
name is the name of the column
anyway when i delete "%" the code works great but when i add them it douesnt work