You can use the order by clause in sql for this. just add: ... order by category, bid_price
to your statement. On 7/16/05, Jegatha <[EMAIL PROTECTED]> wrote: > hi > i have 2 fields in my database > 1.category(i have 3 categories web development,design,seo) > 2.bid price > now i should compare both category and prices(lowest) and i should display > the (asending order) number > > any one help to sort out? > > Thanks in Advance, > > Jegatha. > > > --------------------------------- > Too much spam in your inbox? Yahoo! Mail gives you the best spam protection > for FREE! > http://in.mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > > Yahoo! Groups Links > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> 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/
