Excellent, works like a charm
Many thanks
Steve
Search found 5 matches
- Sun Feb 28, 2010 12:55 pm
- Forum: PHP - Code
- Topic: Number and Letter Order
- Replies: 9
- Views: 174
- Sun Feb 28, 2010 12:37 pm
- Forum: PHP - Code
- Topic: Number and Letter Order
- Replies: 9
- Views: 174
Re: Number and Letter Order
Thanks Dave
Will give that a go and get back to you if I come across any probs
Thanks again Steve
Will give that a go and get back to you if I come across any probs
Thanks again Steve
- Sun Feb 28, 2010 12:04 pm
- Forum: PHP - Code
- Topic: Number and Letter Order
- Replies: 9
- Views: 174
Re: Number and Letter Order
Hi
Thanks but Im not testing the length of the value, I just want it to return numbers in order i.e 1 to 20 followed by letters.
Many thanks
Steve
Thanks but Im not testing the length of the value, I just want it to return numbers in order i.e 1 to 20 followed by letters.
Many thanks
Steve
- Sun Feb 28, 2010 11:22 am
- Forum: PHP - Code
- Topic: Number and Letter Order
- Replies: 9
- Views: 174
Re: Number and Letter Order
Hi
Thanks but tried that and it doesnt work as mysql sees 10 as the next number after 1 e.g 1, 10, 11 etc..
Thanks
Steve
Thanks but tried that and it doesnt work as mysql sees 10 as the next number after 1 e.g 1, 10, 11 etc..
Thanks
Steve
- Sun Feb 28, 2010 4:41 am
- Forum: PHP - Code
- Topic: Number and Letter Order
- Replies: 9
- Views: 174
Number and Letter Order
Hi I hope someone can help. I am having trouble ordering letters and numbers in the same column. I am retrieving information from a mysql database and how I want the output to look is : 1 2 3 upto 20 F H Z If I use ABS() it pushes the letters to the top: F H Z 1 2 3 upto 20 If I take ABS off it puts...