Entry

What is wrong with this: "SELECT * FROM mytable WHERE p_price BETWEEN '$MxPrice' AND '$MnPrice'" ??

Feb 22nd, 2008 03:34
dman, Todor Gaidarov, John Schmidt, http://sturly.com

The Min Price should be before the Max Price. As per mysql help:
expr BETWEEN min AND max