problems with search form numerical "between" sending by php
Posted on
16th Feb 2014 07:03 pm by
admin
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.
Did you know?Explore Trending and Topic pages for more stories like this.
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]')");
while($row = mysql_fetch_array($result))
{
echo $row ['Stock Number'] . " " . $row['Make']." " . $row['Model']." " . $row['Color']." ". $row['Miles']." ". $row['Selling Price'];
echo "<br />";
}
mysql_close($con)
?>
No comments posted yet
Your Answer:
Login to answer
79
7
Other forums
echo $rows help
Hi all,
Hopefully something simple that I don't know!
I have this:
Code: [Selec
Ariba 9r - SAP MM Integration
Hi experts,
The standard Ariba adapter for 9r creates a relationship between Cost Centers
EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t
Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<
Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a
Multi Level Array Problem
hi all,
For example I have array like below:
$temp = array(array('north america', 'us'
Code clarification
Hi
In the following code what could be the "search_print()" and where it could be
Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?
How to display random record from table?
I have the following code:
Code: <?php
$display_block .= "<input type=
Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,