my code is:-

$search=$_POST["search"];
     $sql="SELECT * FROM search WHERE productname ='$search'"; 
      $result = mysql<em>query($sql) or die(mysql</em>error());
             echo "<table border='1'>
                  <tr>
                   <th>Id</th>
                   <th>Product</th>
                   <th>Producy Name</th>
                   <th>Price Per Product</th>
                 </tr>";

    $row = mysql_fetch_array($result);
               extract($row);
           {
             echo "<tr>";
             echo "<td>" . $row['id'] . "</td>";
             echo "<td>"  <img src =". isset($row['product']) . "> "</td>";
             echo "<td>" . $row['productname'] . "</td>";
             echo "<td>" . $row['priceperproduct'] . "</td>";
             echo "</tr>";
            }
          echo "</table>";
  mysql_close($con);