troubles remeving records

[Greg Brant]

i have a news system which runs off the id of the news item,

the system allows the owner to delete a record if the wish,
this removes the record from the database taking with it that auto_incriment
ID

so i would end up with

ID
----
38
39
41
42
etc

so when someone views article 39 and i do

<a href=news.php?id=<?php $id+1; ?> for the "next>>" button and record 40
doesnt exist it errors

how can i resort the table to suffle all the id's so there are no gaps like
this
Thanks

Greg

[Aggro]

Greg Brant wrote:

so when someone views article 39 and i do

<a href=news.php?id=<?php $id+1; ?> for the "next>>" button and record 40
doesnt exist it errors

how can i resort the table to suffle all the id's so there are no gaps like
this

If you don't want re-order id values in your table, you could use a
query like this, to find the next id:

select min(id) from tablename where id > 39;

[Aggro]

Greg Brant wrote:

so when someone views article 39 and i do

<a href=news.php?id=<?php $id+1; ?> for the "next>>" button and record 40
doesnt exist it errors

how can i resort the table to suffle all the id's so there are no gaps like
this

If you don't want re-order id values in your table, you could use a
query like this, to find the next id:

select min(id) from tablename where id > 39;

[Greg Brant]

i want do bump all the ID's down to fill in the empty space left by
deleating a record
"Aggro" <sp**********@yahoo.com> wrote in message
news:OK***************@read3.inet.fi...

Greg Brant wrote:

so when someone views article 39 and i do

<a href=news.php?id=<?php $id+1; ?> for the "next>>" button and record 40 doesnt exist it errors

how can i resort the table to suffle all the id's so there are no gaps like this

If you don't want re-order id values in your table, you could use a
query like this, to find the next id:

select min(id) from tablename where id > 39;

[Greg Brant]

i want do bump all the ID's down to fill in the empty space left by
deleating a record
"Aggro" <sp**********@yahoo.com> wrote in message
news:OK***************@read3.inet.fi...

Greg Brant wrote:

so when someone views article 39 and i do

<a href=news.php?id=<?php $id+1; ?> for the "next>>" button and record 40 doesnt exist it errors

how can i resort the table to suffle all the id's so there are no gaps like this

If you don't want re-order id values in your table, you could use a
query like this, to find the next id:

select min(id) from tablename where id > 39;