Inserting "0" index key, and auto_increm

Anon

In mysql, I am trying to create a news script with php,

Its all done except one problem, i want it to list the news in a desending order, not asending.

So to do this I figured i'd just have mysql insert the new news at the id point of "0".
Figureing that the rest would auto increment when another number is added to the beginning.

How ever that dosen't seem to be the case, does anyone know how I might beable to add a number somewhere in a mysql DB, and have the following numbers auto increment up?

Anon

Well this is not to important now, I found away, which was to take the php script reading the mysql database, and turn it upside down more or less....

It would still be interesting to know if you can make the numbers increase when you add a new digit that is lower then the current ones.

kparker

It would still be interesting to know if you can make the numbers
increase when you add a new digit that is lower then the current ones.

No you can't, because no one would ever really want to in a production environment. Can you imagine how catastrophically slow it would be if every single row in a large table had to be updated with every single insertion?

Fortunately, there's a much easier way--just ORDER the results in reverse order--if you have an index on the column, it will be quite fast:

  select * from articles order by id desc

or, more realistically, limiting it to the last <i>n</i> stories:

  select * from articles order by id desc limit 10

Anon

Yes, I did that.

However I will need to find some way to do something similar to that in the near future, I am starting a gaming ladder that will track ranks, and when one team moves up the ladder it will have to move the others up..

not quite sure how I will accomplish that yet.