Very simple:
File: delete.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Delete rows</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h1>Welcome to the Guestbook Application</h1>
<form name="guestbook" action="guestbook.php" method="post">
What row?: <input type="text" name="id">
<br/>
<input type="submit" name="submit" value="Submit"><input type="reset" name="reset" value="Reset">
</form>
</body>
</html>
File: delete.php
<?php
$id = $_GET['id'];
// Perform query
$query = "DELETE FROM matches WHERE id='$id'";
$result = mysql_query($query) or die(mysql_error());
// Continue query, but check that rows were affected - this is to make sure something happened
$affected = mysql_affected_rows($result);
// Echo the number of rows affected
echo "$affected row(s) were affected.";
?>
I've given you the basics, hopefully you should know HTML and therefore should know that by using the SELECT command from the database, you can retrieve the required ID's and echo them out.
I don't want to write the whole script for you as you need to learn if you're new to PHP, but you should be able to work very easily from this. Simply:
$query = "SELECT id FROM matches";
Then execute the query as shown previously, now run a while loop as below:
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
echo "$id<br/>";
}
mysql_free_result($result);
The above is the key part, that'll echo out all the information ID's on a new line for every ID. You can add extra information and requests to the db etc if you wish.
Hope this made sense,
Chris
