Please click here to go back.");
// Now that we have connected lets make sure
// we are using the proper database
mysql_select_db($db) or die("Unalbe to select from $db database.
Please click here to go back.");
$posted = mysql_query("SELECT * FROM $dbgtbl WHERE post_id LIKE '$post_id'")
or die("
Unable to select from $db database. Please forward this error to the webmaster.
Please click here to go back.");
if ($row = mysql_fetch_array($posted)){
mysql_query("DELETE FROM $dbgtbl WHERE post_id = '$post_id'") or die("Unable to connect to delete $dbgtbl.
Please click here to go back.");
mysql_close($connect);
return (1);
}else{
mysql_close($connect);
return (0);
}
}
// Add a new catagory
function addcat ($cat_name, $cat_desc) {
// We need to set the globals for later use.
global $db,$dbuser,$dbpass,$dbctbl,$dbhost;
$post_date = date("Y-m-d g:i:s");
$entry = "INSERT INTO $dbctbl(cat_name,cat_desc) VALUES('$cat_name', '$cat_desc')";
// Lets connect to the mysql database
$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to $db");
// Lets change to the database we want to use
mysql_select_db($db) or die("Unable to select $db");
// Lets process the insert into the database
$insert = mysql_query($entry) or die("Unable to add entry to $dbctbl");
mysql_close($connect);
// Let check to see if the entry was added.
// If it was then we send back an ok if not
// then we send back a not ok.
if ($insert){
return (1);
}else{
return (0);
}
}
// Delete catagory
function deletecat ($cat_id){
// setup the global variables
global $db,$dbuser,$dbpass,$dbctbl,$dbhost;
// Lets connect to the database
$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to mySQL database.
Please click here to go back.");
// Now that we have connected lets make sure
// we are using the proper database
mysql_select_db($db) or die("Unalbe to select from $db database.
Please click here to go back.");
$posted = mysql_query("SELECT * FROM $dbctbl WHERE cat_id LIKE '$cat_id'")
or die("
Unable to select from $db database. Please forward this error to the webmaster.
Please click here to go back.");
if ($row = mysql_fetch_array($posted)){
mysql_query("DELETE FROM $dbctbl WHERE cat_id = '$cat_id'") or die("Unable to connect to delete $dbgtbl.
Please click here to go back.");
mysql_close($connect);
return (1);
}else{
mysql_close($connect);
return (0);
}
}
?>
