Query Command to reorder a Database

smoochy boys on tour

SoulForge

Dedicated Member
Dedicated Member
Oct 18, 2004
169
7
64
My index columns have mixed them selves up for some wierd reason and i have no idea why or how they managed this and now every time i try and reorder them manually my 1200+ db enteries end up below the 200 db entries :S

Help plz
 

Sammy

Dedicated Member
Dedicated Member
Sep 9, 2007
66
1
54
SELECT *
FROM HL_Stditems
ORDER BY Idx ASC

Try this altho it didnt fix my problem :(
 
Upvote 0