Record 7 has "disappeared" in a registration table to attend an event. It does not appear on the screen when dumping the table with
$query="SELECT * FROM aligxager";
$results = mysql_query($query,$link) or die('Error en la petición SQL.');
$cont = 0;
while ($row = mysql_fetch_array($results)) {
$cont ++;
//Nom
echo '<tr>';
foreach($row as $field) {
echo '<td>' . htmlspecialchars($field) . '</td>';
}
echo '</tr>';
}
mysql_free_result($results);
mysql_close();
Is there a way to find out what is in the registry and how it "disappeared"?
if the record doesn't exist it's hard to figure out what was in that record without a backup.
The most likely reason is that the operation did not complete, if you were in a transaction for example and there was an error, that record is not written but the operation identifier is not retrieved for another operation, therefore the next record would have a jump But this behavior is normal, you don't have to worry.