I am trying to display the results of a search, on a sql database, on a web page. I set up html "select form" and set value to "Between x and x" I get a resource error when submitting the form. I works ok when using "LIKE" or "<" but I cannot get a between to work. The purpose for this is to allow a custormer to search a vehicle inventory by prices between set points. The HTML page the form is <a href="http://www.docwilsonsauto.com/index.html">here</a> there is no php on this page so just view the source.
Here is the code from the .PHP And thank you for reading this I am stumped on why this will not work. The other searches I made work great.
<?php $con = mysql_connect("***********.***.*****","********","******"); if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("docwilson", $con);
$result = mysql_query("SELECT * FROM `Inventory` WHERE `Selling Price`('$_POST[search1]')");