Write Forums

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

79 7 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Fetching array then reversing it 
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar
Cannot Connect to Database 
I am writing an application to do annual reviews. I cannot get my script to work. Whenever it runs I
file_put_contents and createimagefromjpeg 
All,
I do somethings and then I have the following code:
file_put_contents('./test/'.$filename
Remove Rows From Database ad 
Hi All,

I have this:

Code: [Select]<?php
session_start();
include('../com
SELECT * FROM users WHERE Users are not in Blocked 
How do I select all users from users table where there users_id is not stored in the block table
Connecion issue 
Hi,

For some reason, I keep getting this error when trying to connect:

Warning: mysql_
Quick Question about echo value 
Hey guys, I'm trying to get something to show differently in one of my scripts.  I'm trying to make 
problem with script manager 
Hi iam using Net.2005.I have created ajax enabledwebsite.i have master page in which i have script m
Disabling SAP menu 
How do I disable SAP menu for all the users and just restrict them to User Menu in SAP ECC 6.0?