[Resolved] updating numbers in table

[knucklehead]

hello!
i have a table with some records that are numbered from 1-10. sometimes users can delete some of records so their numbers are not 1,2,3,4,5,6,7,8,9,10 but something like 1,2,6,7,8 or something similar... i need to select all these records and update their numbers in a way to look like 1,2,3,4,5.

when i do this

$sql_primers = mysql_query("SELECT * FROM primers WHERE session = '$session' ORDER BY primer_no ASC");
$no_of_primers = mysql_num_rows($sql_primers);

for ($i=1; $i <= $no_of_primers; $i++) {

$sql_update_primer_numbers = mysql_query("UPDATE primers SET primer_no='$i' WHERE session='$session'");

}

all primer numbers are 5 but i need them to be 1,2,3,4 and 5.

sorry for confusing post and thanks in advance!

[dnast]

$sql_primers = mysql_query("SELECT * FROM primers WHERE session = '$session' ORDER BY primer_no ASC");
$no_of_primers = mysql_num_rows($sql_primers);

for ($i=1; $i <= $no_of_primers; $i++) {

  $row = mysql_fetch_array($sql_primers);
  $old_primer_no = $row["primer_no"];
  $sql_update_primer_numbers = mysql_query("UPDATE primers SET primer_no='$i' WHERE primer_no='$old_primer_no'");

}

[knucklehead]

that's it! thanks a lot!