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

[webtuto]

hi ,

well im trying to do a search form for my database here is the 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

[redarrow]

try this...............

<?php

if(!empty($_POST['search']) ) {
$con = mysql_connect("localhost","root","") ;
$db = mysql_select_db("test",$con) ;
$x=$_POST['search'];
$sql = "select * from webt where search='%$x%' ";
$res = mysql_query($sql) or die (mysql_error());
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 name="submit" type="submit" value="Search" >
</form>

[GingerRobot]

If you want to use wildcards, you need to use LIKE, not = :

 

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

 

[webtuto]

thanks it solved