[thelist] MySQl madness

[Paul Bennett]

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