Having problems with creating a CRUD..

[eluser]crumpet[/eluser]
ok heres what you need to do
first of all your table comments needs to have a field called id and that needs to be the primary key. It also needs to be set to auto increment.

your controller needs to have a few different functions:

viewComments(){
//retrieves all comments from the database
//then loads a view called viewComments or something which takes this data and displays it
}
editComment($ID){
//loads a view file called editComment that displyas a form which submits to
//do_editComment($ID)
//this form needs to have hidden field which has the value of $ID
}
do_editComment(){
//takes looks form $_POST('ID') in the comments table and updates it with the rest of hte
//information supplied (the rest of the $_POST array)
}
.. look at the video tutorials for code igniter. he shows how to do hidden fields in the blog one