Solved: Delete MYSQL Rows

[bob121]

Hello,

I was woundering if someone could help me out ,,

what i would like is a script that:

Connects to MYSQL

Accesses my gbook table

Displays A List In PHP Of All The Entrys

And A Delete Button Next To Each one Or When You Click On The Item To Delete The Row

Info You Will Need

DB NAME = carsey_guestbook
UserName = carsey_carsey
password = i will enter that just put in its place "password"

Name Of Items In Row:
Name
Email
Post

I Have Made A Script Like This Before But Can't Seem To Make Them Now , I Believe Its Fairly Easy If You Have An Idea In PHP.

Thanks In Advance James


Also if you do require any extra infomation please do request it.

 

[bob121]

I Have Done This So Far , Not Completly working tho:
It displays each Post and it says i have deleted it when i click on it but dosnt attucaly delete it.
can anyone see an error

<?
switch($_GET['do']) {
default:

$gbook = mysql_query("SELECT * FROM `gbook` ORDER by `name` ASC");
while($n=mysql_fetch_array($gbook)) {
echo("<b>ID:</b> $n[ID]<br/>
    <b>Name:</b> $n[name]<br/>
	<b>Email:</b> $n[email]<br />
	<b>Post:</b> $n[post]<br/>
	<b>Action:</b> <a href=\"gbook.php?do=del&book=$n[ID]\">Delete</a><br/> <br>");
}

break;

case "del" :
	$id = $_GET[book];
	$obtainbooks = mysql_query("SELECT * FROM `gbook` WHERE `ID`= '$ID'");
	$gb = mysql_fetch_array($obtainbooks);
echo ("You've deleted the entry");
	    mysql_query("DELETE FROM `gbook` WHERE `ID` = '$gb[ID]'");
break;
}
?>