updating order of entries

Hi Jason

On a backend page results, I am using an update order function that Ray worked on with me a long time ago and I use on other sites.

I have an issue with one right now. In the database there are currently 37 entries in the 'speakers' table. If I change the entry found at position 1 to, for example, position 7 it gets pushed to 3rd from bottom and not sure how to stop this. It appears that, from the attached, it is down to the fact that the speakerorder column numbers get grouped by the first digit)

How do I get it to group by size of number rather than 'type'?

Thanks

Jamie

see PM

see PM

see PM

see PM

the problem was caused by the SpeakerOrder values not having leading 0s, so the order was being forced:
1
11
12
13
etc..
2
21
22
etc...


I changed the order by to add the leading 0s:
ORDER BY LPAD(CONVERT(SpeakerOrder,CHAR(3)),3,'0') ASC

Thanks. Jason.. Am assuming the change is on the front end speaker.php page rather that the back end results page?

i made the change to:
/admin_cms/speakers_results.php

you may need to update the front end page also.

Brilliant... Thanks Jason. Is there a better solution to achieve this as I do others in future or is this *the* solution?

Cheers

Jamie

I think in this case, the SpeakerOrder column is set to use the varchar data type.

if the data type where set to int for the SpeakerOrder column, the order would not need the leading zeros

as a varchar column it treats the numbers as text,
so:
1
10
11
12
etc is the proper order for text.

if the data type is int, it can recognize that 2 is after 1 in numeric sequence.