The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

it was coming out in ascending order ok until entry number 9, when i entered entry number 10 this was positioned between 1 & 2, the Mysql column was created as a text column but will only have numbers entered in it, so why does it see 10 as less than 9, i tried 10. with same resilt.
Please help I am new to this.

I am on a shared server and using something less than mysql5, what i did was on my pc was drop the column membershipnumber and then added it back in as an INT, now it seems to work fine, did try the cast code as above but got the not known syntax error as i guess thats only good for mysql 5,
anyway i could just delete the column as i done on my pc, but is there a way to just alter that column to change it from TEXT to INT,