You can do using subquiries. for example: select * from yourtable(select * from yourtable desc name) desc officer;
On 1/11/06, p_holsberg <[EMAIL PROTECTED]> wrote: > > I have a database that appears at > http://welcomingthestranger.org/lbc4cc/04-05board.php As you can see, > it is not sorted correctly. I eant the OFFICERS AND BOARD MEMBERS > sorted by office for the officers followed by an alpha list of members > by name (assume that all names will appear as LAST, FIRST). > > Is anyone willing to show me code that will do that? > > Thanks. > > > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > database possibilities through group learning. > > > > SPONSORED LINKS > American general life and accident insurance > company<http://groups.yahoo.com/gads?t=ms&k=American+general+life+and+accident+insurance+company&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=Kzn1J6ZDdsfc3f-9JZ-bKQ> > American > general life insurance > company<http://groups.yahoo.com/gads?t=ms&k=American+general+life+insurance+company&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=q5Z_Gheyyf5dB3KHCkTGOw> > American > general > life<http://groups.yahoo.com/gads?t=ms&k=American+general+life&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=1O42IK5r5LJ1BBWLyTAAKA> > American > general > mortgage<http://groups.yahoo.com/gads?t=ms&k=American+general+mortgage&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=AC-EcyrN2MPgqHTxt6lmKg> > American > general life > insurance<http://groups.yahoo.com/gads?t=ms&k=American+general+life+insurance&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=P8vNlXr7QopQQ3tGIepE4Q> > Computer > internet > security<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+security&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=OCFX-MPv3cQROoYDEaexxA> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "php_mysql<http://groups.yahoo.com/group/php_mysql>" > on the web. > > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > -- ----------- Regards, Ramesh [Non-text portions of this message have been removed] 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/
