Insert row beteewn to old rows.

Insert row beteewn to old rows. I have a database and I need a certain
order of the rows, and would like to insert a row between tod old rows.
Can that be done?

I use phpmyadmin and i belive i once saw such a feature, but I can't
find it now.

(I know your not supposed to use the order in the database)

C

Re: Insert row beteewn to old rows.

madsgormlarsen@gmail.com wrote:
> Insert row beteewn to old rows. I have a database and I need a certain
> order of the rows, and would like to insert a row between tod old rows.
> Can that be done?
>
> I use phpmyadmin and i belive i once saw such a feature, but I can't
> find it now.
>
> (I know your not supposed to use the order in the database)

INSERT places the new row last, if you want it to come out in a different way
you have to change your SELECT query to sort the rows in the order you want
them to be.


//Aho

Re: Insert row beteewn to old rows.

On 2006-02-09, madsgormlarsen@gmail.com wrote:

> Insert row beteewn to old rows. I have a database and I need a certain
> order of the rows, and would like to insert a row between tod old rows.
> Can that be done?

rows don't have predictable order unless you provide it explicitly,

Bye.
Jasen