hi thanks here are they are, i cant find anything wrong with them. Truncate works, but delete does not.
no errors and im using E_ALL and i echoed $rid and it has value, i dont know why they set up an id as var char but the rid is something like this
30ed7b13c560475621c217191fc20216
at first i ran intval($rid) but then i saw it was varchar so then i ran escape on it before the query ran but then i took that off i thought maybe it was preventing it from executing some how.
PHP Code:
//added by dave to remove all connections
if(isset($_POST['removecon'])){
$qry = 'TRUNCATE TABLE '.$GLOBALS['fc_config']['db']['pref'].'connections';
$stmt1 = new Statement($qry, 69);
$rs1 = $stmt1->process();
}//end if
//individual connections
if(isset($_GET['remicon'])){
$rid = $_GET['remicon'];
$query = 'DELETE FROM '.$GLOBALS['fc_config']['db']['pref'].'connections WHERE id='.$rid;
$stmt1 = new Statement($query,69);
$rs1 = $stmt1->process();
}//end if
//end remove connections mod