a friends band asked if i would work on their website. I was happy to say yes. I want to make this a learning experience. I've used a bunch of CMS' but this site I want to be different. I don't want people to look at it and know it is a CMS.

I just put something up so something would be up
http://ghastlycitysleep.com/

When you go there you see a list of their upcoming shows.

I used a simple online form generator that I sometimes use to create a form where they enter the info for the show and it all goes in to a MYSQL database. The info on the main page is info pulled from the database and sorted by date.

So I have figured out how to add news to the database. Now I need help making a page that edits and deletes things from the database. I can usually figure things out on my own if I have a simple example but haven't been able to get this to work.

Will someone help me?
aaricwon@gmail.com

deletion is simple
you need to add a link to each row in the listing like index.php_action=delete&id=the id of that record

then in index.php file you need to check on that
ex:

PHP Code:

if($_GET["action"]=="delete")
{
     mysql_query("delete from tablename where id='$_GET[id]'");
     echo "deleted successfully";
} 


with modify is the same idea but you need to make a form to show old data in text boxes so user can modify it then you need to make a code to get that data and update the required records
mysql update code would be like that

PHP Code:

mysql_query("update tablename set field1='newdata',field2='newdata2' where id='$_GET[id]'");