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.
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
PHP - MySQL Fail
My PHP code will only execute the first part of my code...
Code: <?php
sessio
mail()
Hi all. I have a problem with emails. I am trying to set up a mail system where customers can subscr
form variables from database help.
Hi all,
I would like to have a form that gives you options based on the results of an mysql q
Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student
Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va
CHMOD script
Hi,
I need a script to read all files in a folder and set to 777.
Can anyone help out
Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past
phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";
Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?
I have
I would like "for" to wait 5 sec
I would like my 'for' loop to wait 5 sec before second iteration.
for ($i=0; $i<10