sort on field names; refresh page?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 427,378 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,045 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 4583 | Replies: 1

•

Join Date: Sep 2004

Posts: 2

Reputation: vree is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

vree

Offline

Newbie Poster

sort on field names; refresh page?

Sep 13th, 2004

I only started last week with php mysql(be nice)

I have a MySQL db where a user can enter contact info, usually stuff:
FirstName
LastName
Address
City
State
Zip

I return this info to a php page which shows all info in db.

$result = mysql_query("SELECT * FROM contacts");

I would like to make some sort fields for the page. Sort by LastName or Sort by State.

I know how to write the sql for the query for the db, what I am unsure of is how to use it on the php page and get the page re-displayed when the label is clicked?

hope thats clear. thank you for your time.

•

Join Date: Jul 2004

Posts: 215

Reputation: PoA is an unknown quantity at this point

Rep Power: 5

Solved Threads: 4

PoA

Offline

Posting Whiz in Training

Re: sort on field names; refresh page?

Sep 14th, 2004

Sort by LastName
[PHP]$result = mysql_query("SELECT * FROM contacts ORDERBY LastName");[/PHP]

Sort by State
[PHP]$result = mysql_query("SELECT * FROM contacts ORDERBY State");[/PHP]