apophis Posted January 28, 2003 Share Posted January 28, 2003 Hello, is there someway possible to show cheepest(products_discount4(if it's > 0 else products_discount3 and so on)) price in category listing (as well in new products and etc.) Best rgds, Jan Toomsalu Link to comment Share on other sites More sharing options...
Ajeh Posted January 29, 2003 Share Posted January 29, 2003 You would need to do a select statement that includes the new fields then setup a comparrison CASE or IF statement to pick the right price and make sure you are not comparring the price when the discount is 0 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.