Search the Community
Showing results for tags 'multiple word search php mysq'.
Found 1 result
-
I hate to admit defeat. I created this musical instrument database using various forums. Miraculously it works great except I cannot enter two words in the search form. Anyone have any ideas? Hopefully it is just a tweak.. Here is the PHP part, the form is in an .htm file and passes to this php page. <html> <head> <meta http-equiv="Content-Language" content="en-us"> <title><b> Fender Instruments </b></title> </head> <body> <p><p align="center"><b><a href="http://www.thrume.net/recordapp/webservices/fendersearch.htm"><font size="4">Click Here to Search Again!</a></b></p> </body> </html> <? mysql_connect("fenderjazzxxxxxx.com","fenderjazz","password..XXXXXX"); @mysql_select_db("fenderjazz") or die( "Unable to select database"); $term = $_POST['term']; $result = mysql_query("select * from fenderjazz where description like '%$term%' ORDER BY salesprice DESC"); $num=mysql_numrows($result); mysql_close(); echo "<b><center>FenderBlog.com</center></b><br><br>"; ?> <table border="0" cellspacing="2" cellpadding="2"> <tr> <th><font face="Arial, Helvetica, sans-serif">Description</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Sold</font></th> <th><font face="Arial, Helvetica, sans-serif">Sales Price</font></th> </tr> <? $i=0; while ($i < $num) { $description=mysql_result($result,$i,"description"); $datesold=mysql_result($result,$i,"datesold"); $salesprice=mysql_result($result,$i,"salesprice"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><? echo "$description"; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo "$datesold"; ?></font></td> <td>$<font face="Arial, Helvetica, sans-serif"><? echo number_format("$salesprice", 2, '.',','); ?></font></td> </tr> <? ++$i; } echo "</table>"; ?>