The Test Scenario - PHP

This article will show you the fastest way to order your database results, via JavaScript (with some work in PHP). It adds some more work to your script, but once you see the results you won't use the approach of adding the ORDER By clause anymore.

TABLE OF CONTENTS:

By: Alvaro Calleja

Poor Best

Rating:

/ 13

December 06, 2004

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

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

CREATE TABLE products (
ID smallint(5) unsigned NOT NULL auto_increment,
NAME varchar(125) NOT NULL default '',
PRICE float(8,2) NOT NULL default '0.00',
CODE varchar(10) NOT NULL default '',
WEIGHT smallint(5) unsigned 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);