Re: PHP & MYSQL sorting

At 8:16 PM -0400 4/11/10, Ernie Kemp wrote:

Simple idea I thought. I need a webpage that displays a drop down list of number with a checkbox on the side that when checked will select the database again only in descending order. Small database with maybe 100 records. The user can click the submit button when they have located the correct number. The trick is to make the checkbox trigger a new Select statement. Thanks.

Ernie: <form name="myForm" action="" > <input type="checkbox" name="sort" id="sort" onClick="getData(this)" > </form> The javascript getData() will have to launch a php script to get the data again OR you can simply sort the data yourself using sort(). Here's another idea using jQuery: http://webbytedd.com/jquery/sortable-table/ Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com