I currently have a mysql query set up with the order like this:
ORDER BY LTpricetoday, LTafterrebates ASC, id DESC LIMIT 0, 20
I have added another product line, so now I need it to order by both LTpricetoday and BWpricetoday, so the ones with the smallest price today show up first - whichever it is.
Then after that, LTafterrebates would be the secondary order, id the last.
Does that make sense? It is possible?