Create a field lowest_price. Make one pass to fill lowest_price, then sort by lowest_price.
Gerry On 7/13/06, Mark Wheeler <[EMAIL PROTECTED]> wrote: > Hi all, > > I've got a query I can't seem to figure out how to write. Here's the > table structure: > > price_1X, price_2X, price_3X, price_4X, price_1Y, price_2_Y, > price_3Y, price_4Y > > There are 200 to 300 entries in this table. The price_1X needs to be > compared to price_1Y, price_2X to price_2Y, etc. Think of it as a > price comparison between two different companies. As well, some of > the fields may be empty. > > What I'm trying to do is find the lowest price in each entry, then > sort all the entries by that lowest price. Does anyone have an idea > of how to do this? > > Thanks, > > Mark > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > database possibilities through group learning. > Yahoo! Groups Links > > > > > > > -- Gerry Danen Developer support: http://dev.danen.org/ http://groups.yahoo.com/group/php_and_mysql/ Lily Register: http://www.lily-gallery.com/ ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
