Item positioning on the site with php and mysql

[pbcomm]

Hey all,
I have a problem with item position on my site. I have about 300 items that I need to keep in order. Puting up/down arrows will not work cause I'll kill myself before I get newly added item to positon 5.

What I wanted to have is the text box next to the item where I can change its position. I don't care if I have to do it one item at a time with a button next to each item, the only requirement is that the numbers have to be unique from 1 to 300.

Anyone has any ideas? maybe a script that already exists?

[Sxooter]

I'd create an int field in the database called something obvious like orderby (no spaces...) and put a unique key on it.

Then, order by that one.

Here's the trick. Use numbers with spaces between them to start. I.e. the first item is 100, then 200, then 300, then 400.

Now, when you add a new item, there's plenty of free space between the numbers already assigned to stick the new items into. Split it. New item between the ones at 300 and 400? number it 350... and so on.