Thanks for your thoughts. Ajax is the way to go... Thanks, .../Ernie -----Original Message----- From: tedd [mailto:tedd.sperling@xxxxxxxxx] Sent: April-12-10 10:18 AM To: Ernie Kemp; 'PHP General List' Subject: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2806 - Release Date: 04/12/10 02:32:00 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php