Re: Guestbook
| From: | Jeffrey B. Ferland | Date: | Mon, 02 Dec 2002 00:55:46 +0000 |
| Subject: | Re: Guestbook | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-126656@lists.php.net to get a copy of this message | ||
> 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