Cannot delete from database

I need to figure out how to reset the auto increment in the database if I can.  At least I think this is the best way to proceed.

No it's not.
Let your controller fetch the records (optionally via a model), and pass them as an array to the view that shows the table.
Use a foreach... structure to display the records.

Very basic example:

Code:

<table>
<?php foreach ($posts as $post) : ?>
 <tr><td><?= $post->title;?></td><td><?= anchor('posts/delete/' . $post->id,'Delete');?></td></tr>
<?php endforeach; ?>
</table>

This way, each delete button refers to an existing record.

Thanks,  Even though I fixed the issue I'm in the learning mode and I'm going to take your advice and fetch the records in the Model.  For me it's a challenge as I believe it will help me learn how to structure the code better.

Again thanks for your input I really appreciate it.