SQL In Order ?

[Blimey]

How can i make it put things in order using ID ? Really annoying trying to organise stuff atm lol

 

[TheMightyOne]

This can't be done, you have to re-number everything. If your having trouble getting it to stay in order after adding new items, then I can tell you how to do that?

 

[Tai]

Wrong section again...we have a Help section you know

Unless it's directly and specifically to do with the ruby files and you need an answer from a coder, please use the mir 2 help section

 

[Blimey]

Ok will do, sry.

Well i started with a fresh DB, but ive been copy n pasting items in. And they are all mixed up, so i want to renumber the IDs then they all go in order lol. Help!

 

[Mask]

export the db into excel and copy and paste the tables into the order you want, then reimport into sql.

 

[Lilcooldoode]

This can be done very easily btw:

After you have opened the item table:

1. Click the button to show the SQL Pane (Shows the script SQl used to display item rows)

2. At the end of the script add the following:
ORDER BY ID

(ID is column name for Ruby item DB)

3. Execute the script, job done.

 

[Gezza]

This can be done very easily btw:

After you have opened the item table:

1. Click the button to show the SQL Pane (Shows the script SQl used to display item rows)

2. At the end of the script add the following:
ORDER BY ID

(ID is column name for Ruby item DB)

3. Execute the script, job done.

wish i knew this years ago lol