can anyone help with the sql for searching Mysql for a price.
Each product has 5 price feilds and I want to be able to search all five for a maximum price via a search
e.g. max price is entered as ?00
So the search then checks the 5 price feilds on a product and if one of those 5 are lower than the maximum price, it adds them into the result.
Each product has 5 price feilds and I want to be able to search all five for a maximum price via a search
e.g. max price is entered as ?00
So the search then checks the 5 price feilds on a product and if one of those 5 are lower than the maximum price, it adds them into the result.