> The quick solution, if you intend to continue the autoincrement field, is to > number the entries manually when you're displaying them: Something along the > lines of: > > $count = 0; > while ($row(mysql_fetch_array($result_id))) { > $count++; > echo "Entry $count"; > ... > ... > }
The right solution (and not much slower) is to use a different table type for your DB. Read up on what different tables types in your DB support. Note that this won't make any difference if the one you're deleting isn't the last one in the series... there basically isn't a work-around for that which doesn't eat proc time. -Jeff SIG: HUP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php