Nee help for this code

[spluskhan]

suppose i have 10 products in my database
Example:
iphone 2 - iphone 3g - laptop i3 - laptop i7 - nokia n96 etc

when i enter iphone in my search i see all records stored in database thats my prob!

what i want ?
suppose if i enter laptop i7 or laptop then i get result for laptop i7 or laptop

here is my code..

<?php 
// Connects to your Database 
mysql_connect("host.com", "userr", "pass") or die(mysql_error()); 
mysql_select_db("products") or die(mysql_error()); 

$data = mysql_query("SELECT * FROM Products") 
or die(mysql_error()); 
Print "<table border cellpadding=3>"; 
while($info = mysql_fetch_array( $data )) 
{ 
Print "<tr>"; 
Print "<th>Name:</th> <td>".$info['name'] . "</td> "; 
Print "<th>new:</th> <td>".$info['new_price'] . "</td> "; 
Print "<th>old:</th> <td>".$info['old_proce'] . "</td> "; 
Print "<th>faulty:</th> <td>".$info['Faulty_price'] . " </td></tr>"; 
} 
Print "</table>"; 
?>

if any one have better code then please give me tankxx

[NogDog]

That's what a WHERE clause is for in your SQL. If you need to support "fuzzy" searches based on whatever text a user enters, you may want to look into using FULLTEXT indexes and their related function in your database and SQL.