so i got a table, lets say for example
CREATE TABLE data (
id mediumint(9) NOT NULL auto_increment,
targets mediumint(9) NOT NULL default '0',
variance mediumint(9) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO data VALUES (1, 5, 8);
INSERT INTO data VALUES (2, 5, 40);
INSERT INTO data VALUES (3, 5, 34);
INSERT INTO data VALUES (4, 3, 41);
INSERT INTO data VALUES (5, 3, 39);
INSERT INTO data VALUES (6, 4, 13);
INSERT INTO data VALUES (7, 4, 14);
now, on my php page, i want to retreive the rows of data, lets say in this format :
row id = 2; targets = 5; variance = 40;
row id = 3; targets = 5; variance = 34;
row id = 1; targets = 5; variance = 8;
row id = 7; targets = 4; variance = 14;
row id = 6; targets = 4; variance = 13;
row id = 4; targets = 3; variance = 41;
row id = 3; targets = 3; variance = 39;
in other words
ORDER BY targets DESC, variance ASC;
but it dont work.
any fantastic ideas guys?
