[thelist] Database Normalization Question

Greg Burnison gburniso at scratchpad.ca
Tue May 14 14:00:01 CDT 2002


You should be able to sort by using the fields in your existing table.  If
you are using SQL you can add the statement ' ORDER BY <colname>' onto the
end of your SELECT statement to have it ordered by that column.

HTH
Greg

At 11:28 AM 5/14/2002, you wrote:
>--
>[ Picked text/plain from multipart/alternative ]
>I have a database which has a table with contact information.  I want to
>display this contact information on multiple web pages depending on certain
>criteria.
>
>Would I want to put fields in the table with the contact information to use
>to sort on or would I need to set up a second separate table which will hold
>the sort fields?
>
>Thanks,
>Josh
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of thelist go to:
>http://lists.evolt.org Workers of the Web, evolt !



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com



More information about the thelist mailing list