Cannot delete from database

Please, define "didn't work".
What happens if you click on the button?
Nothing? Or does it load the requested URL and then nothing happens?
Please, insert the following line of code in the posts/delete function, right after the last this->db-> action:

PHP Code:

echo $this->db->last_query();
die(); 


Pls, tell us what it says.

Hi, and thanks for your time.

When I hover over the button it shows the url localhost/ci-template/posts/delete/1
When I click on the button it redirect back to the page where the table is.
This is what I received after inserting the code you sent me: DELETE FROM `posts` WHERE `id` = '1'

I figured it out.  The id that codeigniter is trying to delete doesn't match the id in the database.  Probably from me deleting them from testing.  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.

$post['id'] <- is not the id from the database?

if you need to reset the id, you do something wrong very wrong