inserting new data in to exisiting data

Anon

How would we get around the following problem. For instance If I ran a restaurant and have my menu online. I can add new records, update and delete, but how would I add data in the middle of the exisiting menu, where I want it. Using the INSERT TO tag will either put the new entry to the bottom of the list or the top. I would use an auto i.d. I have thought of date and time stamping each entry, but again I dont think this would work. Any other ideas?

fish and chips £4.50
beans on toast £4.23
egg on toast £1.34

Anon

Why do you care where a new record is inserted? As long as you have an auto_increment column, or some primary key, you can always retrieve any record unambigiously.

Richie.
geocities.com/akindele/

Anon

but do you see what I am talking about.

o.k let me put it in a better way.

beans
chips
coke
7up

The following menu is called from the database. I want to add another dish to it. The dish must be added between beans and chips. I dont want it to appear at the top or at the bottom. It has to go in the middle. How would I do this.

Anon

You have to sort the results. If in alphabetical order, try this:

SELECT dishes FROM food_table <B>ORDER BY dishes ASC</B>

This would read

7up
beans
chips
coke

Or this one:

SELECT dishes FROM food_table <B>ORDER BY dishes DESC</B>

This would read

coke
chips
beans
7up

Other that that, you have to store the results into an array and the sort that array in the order you want. Or sort the results by another field.

Hope this helps

fLIPIS