[Resolved] How do to this??

Manat

Hi all,

I have an online catalog on my extranet, and in my online catalog we have products... obviously.  But each product has a price range and not suggested retailer prices.

I want to be able to search by price range.

0-10$
10-20$
ect...

But the problem is that there are intersections, like how would 5-15$ fit in the above search?

I was going to create a priceRangeID, but with these intersections I don't know how to start.

Can anyone give me any pointers or advice?

Thanks
mK

devinemke

i assume the catalog is stored in a database. if so then perhaps store the min and max price in two separate INT fields. then you can use simple comparison operators:

SELECT * FROM catalog WHERE min_price >= 5 AND max_price <= 15

Manat

Thanks,

Don't know why I didn't think of that, i'll try that out im sure it will work.

Thanks a bunch dude!
🙂

Manat

Hi,

What would the SQL be if the product info is in the product table, with a price range ID.

And in the price_range table, there is the min_Price and max_price fields???

Thx
MK

devinemke

how do the two tables relate to each other? what is the data structure?

Manat

in the products table there is a price_range_id
in the price table there is a price_range_id and a price_range field. Also in the price_table there are the min_price and max_price as noted above.

Basically, I have to do a:

Select Price_Range_ID FROM Price_Range WHERE min_price >= $min AND max_price <= $max

And then,
Select * from ProductTable where productPrinceRange = Price_Range_ID(this goes in some loop I guess)

But im not sure how to architect this, anyone?

Manat

Can I do something like this, if so how?

$rows = mysql_num_rows($result);
for ($i=0; $i < $rows; $i++){
list($id,$numOrder) = pg_fetch_row($result,$i);

And the where clause here
}

????

Any help would be apreicated

Manat

anynoe?