$data = mysql_query("SELECT id ,name FROM imagetable")
or die(mysql_error());
$id=0;
while($info = mysql_fetch_array( $data )) {
$id=$id+1;
mysql_query("UPDATE imagetable SET id =$id where...

i have updated $id but still the problem persists
the loop is execute completely on a row and only after that it goes to the next row
this is why every row has same number
help me solve this

if a row is deleted the sequence will be destroyed can you suggest me any way to update the id.
i've done using following code


$id=1;
$count = mysql_num_rows( mysql_query("SELECT image_id FROM...

Is it possible to update the AUTO_INCREMENT value who's attributes are primary key, not null, auto increment and also an INT type

The thing is I need to synchronize the 'image_id' to access images...