Re: php & sorting rows

by "rudy" <rudy937(at)rogers.com>

 Date:  Wed, 29 Jan 2003 19:56:14 -0500
 To:  <franic(at)qis.net>,
<hwg-techniques(at)mail.hwg.org>
 References:  localhost
  todo: View Thread, Original
> What I can't figure out is how to sort the rows 

frani, change your query from

  SELECT * FROM lifemem 
    WHERE council = 'Allegany'

to

  SELECT * FROM lifemem 
    WHERE council = 'Allegany' 
    ORDER BY lname

this way, the database does the sort, you just print


rudy

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA