Help Me.............

[Anon]

I want to delete a data from 2 tables using this code but its not work..only 1 work but another one is not..

Only data in table AddressBook that can be deleted but not in Detail...

Any body can help me?

From fail.php3

// del entry
if($delItem != \"\") {
if($addrID == \"\") { // but nothing selected
$addrDelNoneSelectedErr = 1;
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}
$del_rc = $sql->addr_delitem($addrID, $userdomain);

// The Rock Said ...
if ($del_rc !=\"\")
{
$del_rcd = $sql->addr_detail($addID,$Fname);
}
// Stone Cold

if($del_rc == false) {
$addrDelErr = 1;
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}

// notify the user
$addrDelDone = 1;
// load the addressbook again
$addr_cnt = load_abook($userdomain);
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}

Database
SQL Command

// del entry
if($delItem != \"\") {
if($addrID == \"\") { // but nothing selected
$addrDelNoneSelectedErr = 1;
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}
$del_rc = $sql->addr_delitem($addrID, $userdomain);

// The Rock Said ...
if ($del_rc !=\"\")
{
$del_rcd = $sql->addr_detail($addID,$Fname);
}
// Stone Cold

if($del_rc == false) {
$addrDelErr = 1;
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}

// notify the user
$addrDelDone = 1;
// load the addressbook again
$addr_cnt = load_abook($userdomain);
include(\"htx/addressbook.htx\");
include(\"htx/footer.htx\");
my_exit();
}

   if($ar == 0) return false
   else return true;

}

// delete TABLE Detail
function addr_detail($id
$query =\"DELETE FROM Det
$rcd = mysql_query($quer
if ($rcd == false) retur
$ard = mysql_affected_ro
if($ard == 0) return fal
else return true;

// delete an entry
function addr_delitem($id,$userdomain) {
$query =\"DELETE FROM AddressBook WHERE ItemID=\'$id\' AND OwnerUD =\'$userdomain\'\";
$rc = mysql_query($query);
if($rc == false) return false;
$ar = mysql_affected_rows($this->socket);
if($ar == 0) return false;
else return true;
}

// delete TABLE Detail
function addr_detail($id) {
$query =\"DELETE FROM Detail WHERE ItemID=\'$id\' AND f_Name=\'$Fname\' \";
$rcd = mysql_query($query);
if ($rcd == false) return false;
$ard = mysql_affected_rows($this->socket);
if($ard == 0) return false;
else return true;

}

// delete an entry
function addr_delitem($id,$userdomain) {
$query =\"DELETE FROM AddressBook WHERE ItemID=\'$id\' AND OwnerUD =\'$userdomain\'\";
$rc = mysql_query($query);
if($rc == false) return false;
$ar = mysql_affected_rows($this->socket);
if($ar == 0) return false;
else return true;
}

// delete TABLE Detail
function addr_detail($id) {
$query =\"DELETE FROM Detail WHERE ItemID=\'$id\' AND f_Name=\'$Fname\' \";
$rcd = mysql_query($query);
if ($rcd == false) return false;
$ard = mysql_affected_rows($this->socket);
if($ard == 0) return false;
else return true;

// delete an entry
function addr_delitem($id,$userdomain) {
$query =\"DELETE FROM AddressBook WHERE ItemID=\'$id\' AND OwnerUD =\'$userdomain\'\";
$rc = mysql_query($query);
if($rc == false) return false;
$ar = mysql_affected_rows($this->socket);
if($ar == 0) return false;
else return true;
}

// delete TABLE Detail
function addr_detail($id) {
$query =\"DELETE FROM Detail WHERE ItemID=\'$id\' AND f_Name=\'$Fname\' \";
$rcd = mysql_query($query);
if ($rcd == false) return false;
$ard = mysql_affected_rows($this->socket);
if($ard == 0) return false;
else return true;

}