[thelist] MySQl madness
Paul Bennett
paul at teltest.com
Tue Dec 9 20:43:51 CST 2003
Tony Crockford wrote:
> Maybe it's my choice of music or maybe it's just old age but how can
> the following list be ordered by cd_title?
>
> cd_ref cd_title cd_desc
> 5 Used Unrestored good used condition fully
> working
> 2 A1 Restored Perfect restored Condition
> 1 A1 Unrestored Perfect unrestored Condition
> 4 Pattern only Very poor condition to be used
> onlt for patterm ma...
> 3 Urgent action Poor Condition. Preservation
> required to prevent l...
>
>
> This is the mySQL query:
>
> SELECT * FROM cond_def ORDER BY cd_title
try 'order by cd_title ASC'
to ascend in alphabetic order
also check there is no space in front of the 'Used Unrestored' title
--
------------------------------
Paul Bennett
Internet Developer
Teltest Electronic Design
------------------------------
Email: paul at teltest.com
Phone: 64 4 237 4557
Web: http://www.teltest.com
Wap: http://wap.teltest.com
More information about the thelist
mailing list