I have a form to delete the entered items, like
$sql="DELETE FROM t2790 WHERE product_id = '".$q."'";
When I enter a new row after deleting all the inserted rows, the auto increment still fill out the filed with number 11 instead of number 1.
how to update the field value to be like 1 - 2 - 3 - 4 - 5 - ... after deleting for example row number 3?