Home arrow JavaScript arrow Sorting the Easy Way
JAVASCRIPT

Sorting the Easy Way


I bet most of us have developed an application where a list of products were retrieved from a database and shown in a table with their name, price and code. So we placed a cute little icon near each column's header that linked to the search page with a flag in the URL to let it know we wanted the results ordered by name or price. The search script kindly did its job, adding the ORDER BY clause, and the ordered results were shown to the user. Obviously this method works, but there is a problem: Why must we bother the server again to retrieve the same results that are now held in the browser, only in a different order? This article will show you the quickest way to order your database results, via JavaScript, with some work in PHP.

Author Info:
By: Alf A. Pedersen
Rating: 4 stars4 stars4 stars4 stars4 stars / 10
March 17, 2004
TABLE OF CONTENTS:
  1. · Sorting the Easy Way
  2. · The Basic Code
  3. · We Love INNERHTML!
  4. · See What We've Done...
  5. · PHP Sorting

print this article
SEARCH DEVARTICLES

Sorting the Easy Way
(Page 1 of 5 )



The Test Scenario

First of all, we'll create a products table in our MySQL test database and insert some records into it:


CREATE TABLE products (
  
ID smallint(5unsigned NOT NULL auto_increment,
  NAME varchar
(125NOT NULL default '',
  PRICE float
(8,2NOT NULL default '0.00',
  CODE varchar
(10NOT NULL default '',
  WEIGHT smallint
(5unsigned NOT NULL default '0',
  PRIMARY KEY 
(ID)
  
TYPE=MyISAM;
INSERT INTO products VALUES (1'Absolute Delight''2.20''59'50);
INSERT INTO products VALUES 
(2'Aqua Mirabilis''2.35''114'15);
INSERT INTO products VALUES 
(3'Back For Breakfast''8.30''1409'500);
INSERT INTO products VALUES 
(4'Breeze on a Sea Air''5.95''223'75);
INSERT INTO products VALUES 
(5'Figs and Leaves''3.90''22819'100);
INSERT INTO products VALUES 
(6'I love Juicy''5.95''2006'250);
INSERT INTO products VALUES 
(7'Ocean Salt''9.75''2128'150);
INSERT INTO products VALUES 
(8'Serenity''49.95''2083'350);
INSERT INTO products VALUES 
(9'Tisty Tosty''2.35''5'60);
INSERT INTO products VALUES 
(10'Waving Not Drowning''1.95''15'40);



If nothing went wrong we should have our products table with 10 records. Roll up your sleeves; we are now ready to jump into the actual code!



blog comments powered by Disqus
JAVASCRIPT ARTICLES

- Project Nashorn to Make Java, JavaScript Wor...
- JavaScript Virus Attacks Tumblr Blogs
- Google Releases Stable Dart Version, JavaScr...
- Khan Academy Unveils New JavaScript Learning...
- Accessing Nitro? There`s an App for That
- JQuery 2.0 Leaving Older IE Versions Behind
- Fastest JavaScript Engine Might Surprise You
- Microsoft Adjusting Chakra for IE 10
- Brendan Eich: We Don`t Need Google Native Cl...
- An Overview of JavaScript Statements
- An Overview of JavaScript Operators
- Overview of JavaScript Variables
- More of the Top jQuery Social Plugins
- The Top jQuery Social Plugins
- More of the Top jQuery Slider Plugins

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials