<?php
// Delete event data
if ($_REQUEST['delete']){

	// open connection to MySQL server
	$connection = mysql_connect('localhost:80', 'username', 'password')
	or die ('Unable to connect!');
		
	//select database
	mysql_select_db('test') or die ('Unable to select database!');
	
	//define variables
	$eventSelect = $_POST['eventSelect'];
	
	//create and execute query
	$query = "DELETE FROM event WHERE heading = '$eventSelect'";
	$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
		
	// close connection
	mysql_close($connection);
}
?>

<td>
<?php 
// open connection to MySQL server
$connection = mysql_connect('localhost:80', 'username', 'password')
or die ('Unable to connect!');
					
//select database
mysql_select_db('test') or die ('Unable to select database!');
					
//create and execute query
$query = 'SELECT heading FROM event ORDER BY heading';
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
					
//create selection list
echo "<select name='events' value='-'>\n";
echo "<option value='Select event'>Select an event to be edited\n";
while($row = mysql_fetch_row($result))
  {
    $eventSelect = $row[0];
    echo "<option value='$eventSelect'>$eventSelect</option>\n";
  }
echo "</select>"
?>					
<input name="edit" type="submit" class="submitForm" value="Edit">
<input name="delete" type="submit" class="submitForm" value="Delete">
</td>

 
//create selection list
echo "<select name='events'>\n";
echo "<option value='Select event'>Select an event to be edited\n";
while($row = mysql_fetch_row($result))
  {
    $eventSelect = $row[0];
$eventid = $row[1]; //set this to the column of th primary key
    echo "<option value='$eventid'>$eventSelect</option>\n";
  }
echo "</select>"

 
//define variables
	$eventSelect = $_POST['eventSelect'];
 
	//create and execute query
	$query = "DELETE FROM event WHERE heading = '$eventSelect'";
 

 
//define variables
	$eventSelect = $_POST['events'];
 
	//create and execute query
	$query = "DELETE FROM event WHERE id = '$eventSelect' LIMIT 1";