0

i m trying to compare 2 price
for example when person enters min price as 3000$ and max price as $10000.and press search .it has to search all the price bewtween 3000$ to 10000$.i think the select option for price in cars.com best describe my problem
i dont know how to proceed. i m new to php.i hope u guide me
thanks

3
Contributors
4
Replies
5
Views
12 Years
Discussion Span
Last Post by digital-ether
0

i m searching the price from the database within particular range.
suppose i want to search between 1 to 10. search should display all information between the price range 1 to 10.
in cars.com price search is there. i want to search taht type

0

SQL does the actual searching. PHP connects to the database, executes the queries, and formats the results. What part of the process do you not understand?

0

i m trying to compare 2 price
for example when person enters min price as 3000$ and max price as $10000.and press search .it has to search all the price bewtween 3000$ to 10000$.i think the select option for price in cars.com best describe my problem
i dont know how to proceed. i m new to php.i hope u guide me
thanks

aarya,
The database will select the db listings in the price range for you if you specify in the sql query.

eg:

$sql = "SELECT * FROM table WHERE price > '$price1' AND price < '$price2';

in teh example $price1 is the min price and $price2 is the max price.

;)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.