Nee help for this code
suppose i have 10 products in my database
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..
if any one have better code then please give me tankxx
// 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")
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
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>";
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)