Just a thought

[Anon]

I had a thought about mysql and thought of an example and wondered if this is possible. Lets pretend I am restaurant owner. I display my menu online. The menu is called from mysql and shows all the dishes that I can serve up.

I am given the facility to update my menu and add new recrds as new dishes are intorudced. This inturn updates my main menu online.

I was wondering if it possible to add entries in to the middle of exisiting ones, instead of it appearing at the top or bottom of the menu.

There is one way I could possibly get round this.

Enter the I.D numbers manually but each i.d goes up 20 each time, giving me space to add new dishes in between.
The menu then be called in numerical order.

I was thinking is it possible to set auto_id to step up 20 each time. When a new dish needs to be added 1 would be added to the I.D above therefore giving me a new record number and therefore allowing me to add records in between others.

I hope this makes sense, if you have any ideas on how you would do this I would be interested in hearing about it.

[greg252]

What happens when you try to add 21 dishes in between 2 entries?

Better way would be to list all items within a given section and use a numbering system (possibly with javascript to prevent duplicate numbers) to order the items.

I will be starting a project very similar to this in about a month. If you'd like to talk more, e-mail me at [e-mail]

Greg

[Anon]

Leave item_id as a regular primary key. Add a new column called order. Then, sort your result by 'order'. In the admin, have features for moving items up and down a certain number of places.

Chris