rlugo
Joined: 18 Dec 2007
Posts: 4
Posted: 2007-12-23 20:09
Back to top
Reply with quote
|
Hi all,
I am trying to sort this alphanumeric data:
1000MB
100MB
12MB
Into this:
12MB
100MB
1000MB
I tried hacking the phpMyEdit.class.php with this code:
...
if ($parts['orderby'] != '')
$ret .= ' ORDER BY CAST('.$parts['orderby'].' AS UNSIGNED),'.$parts['orderby'];
...
but I get the following error:
MySQL error 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`PMEtable0`.`Id` AS UNSIGNED),`PMEtable0`.`Web Space`,`PMEtable0`.`Id` LIMIT 0, ' at line 1
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
