SQL/PHP delete error

TobyRT

Hi all,

I've amended the below code from the Intranet Journal CMS Tutorial. It all seems to be working fine - I've managed to add entries successfully and, as you'll see from the code below I can list the entries with a "delete" option for an admin page. The problem I'm having is that when i try and delete it tells me theres an error and it couldn't delete the entry.

I'm fairly sure I'm missing something obvious, but I can't work out what it is. I'm guessing it's something to do with the Validator.php file, but again, I'm not sure exactly what i'm looking for - sadly the error messages aren't that clear!

I'd be really grateful for some help with this!

Here is the admin page code:

TobyRT

oops - forgot to post the code

<?php // Require the classes
require_once('../includes/DbConnector.php');
require_once('../includes/Validator.php');

// Create an object (instance) of the DbConnector and Validator
$connector = new DbConnector();
$validator = new Validator();

// DELETE SECTIONS ////////////////////////////////////////////////////////////////////
if ($HTTP_GET_VARS['action'] == 'delete'){

// Store the section ID to be deleted in a variable
	$jobID = $HTTP_GET_VARS['ID'];

// Validate the sectionID, and if it's ok delete the section
if ( $validator->validateNumber($jobID,'Job ID') ){

	// The validator returned true, so go ahead and delete the section
	$connector->query('DELETE FROM jobs WHERE ID = '.$jobID);
	echo 'Job Deleted.<br>';
}else{
	// The validator returned false, meaning there was a problem
	echo "Couldn't delete. There was a problem with: ".$validator->listErrors();
}
}

// LIST SECTIONS /////////////////////////////////////////////////////////////////////
$result = $connector->query('SELECT ID,publisher,role FROM jobs');
// Get an array containing the results.
// Loop for each item in that array
while ($row = 

$connector->fetchArray($result)){
	echo $row['ID'].'&nbsp;-&nbsp;'.$row['publisher'].'&nbsp;-&nbsp;'.$row['role'];
// Show the name of job
	echo '<a href="editSections.php?action=delete&id='.$row['ID'].'"> Delete </a>';// 

Show the delete link 
	echo '<br>'; // Show a carriage return
}
?>
<html>
<head>
<title>Edit Sections</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body></body></html>