mysql index re-order problem

hello guys,

need your help I new to php and mysql, I have a simple mysql database that accepts name phone number, my problem is when i delete a record. something like below:

index name phone
1 john 1234567
2 mike 4301111
3 jenny 5112378

when I delete jenny in a record the database will show
index name phone
1 john 1234567
2 mike 4301111
4 sonny 8331799

my question is how can my make the index re-order/show the correct number of data when I delete a record. pls show me some sample codes.

thanks

Eh, this isn't how the auto increment field is to be used.

To get the total number of records you have, you can do: SELECT COUNT([your ID field]) FROM [your table name]

To count the rows, I'd recommend just using a counter in your while() recordset loop and print the counter for each row you print.

For example:

$rowcount = 1;
while($row = mysql_fetch_array($recordset))
{
  echo $rowcount . '. ' . $row['myfield'] . '<br />';
  $rowcount++;
}  // end while(...

Something like that...

Originally posted by nytfox05
my question is how can my make the index re-order/show the correct number of data when I delete a record.

you don't. read this.