Page 1 of 1

Price range coding

Posted: Wed Jul 11, 2007 5:15 pm
by slomotion
I tried to search for different things in mysql and php but couldnt find anything

I am trying to list a price range for products

example: $XXX - $XXX

pulling it from a list in mysql. I was wondering if anyone had any idea of where to get some ideas?

Thanks ahead of time.

Posted: Wed Jul 11, 2007 5:20 pm
by feyd
You're probably looking for the BETWEEN construct.

http://dev.mysql.com/doc/refman/5.1/en/ ... on_between

Posted: Wed Jul 11, 2007 5:45 pm
by slomotion
close but I guess i didnt explain myself good enough. I am looking to list the lowest price possible right next to the highest possible price. I haven't been able to think of any way to do that.

Im having difficulty getting each of the two values and displaying them.

//Yes I am a newbie

Posted: Wed Jul 11, 2007 6:37 pm
by slomotion
I figured it out, I feel like an idiot now that I couldnt figure it out