Search found 5 matches

by espy69
Sun Feb 28, 2010 12:55 pm
Forum: PHP - Code
Topic: Number and Letter Order
Replies: 9
Views: 174

Re: Number and Letter Order

Excellent, works like a charm

Many thanks

Steve
by espy69
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
by espy69
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
by espy69
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
by espy69
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...