macromedia.dreamweaver.appdev
[Top] [All Lists]

Re: Delete Multiple records

Subject: Re: Delete Multiple records
From: "Pat Shaw"
Date: Mon, 29 Sep 2008 19:07:39 +0100
Newsgroups: macromedia.dreamweaver.appdev

Use referential integrity in your database. That way, you only need issue 
one delete command and all 3 related tables will be effected. As far as I 
know, MySQL does support RI or perhaps someone can tell me different as I 
come from the SQL Server camp.

"Prellyan Luxtintner" <webforumsuser@xxxxxxxxxxxxxx> wrote in message 
news:gbqkb6$8cs$1@xxxxxxxxxxxxxxxxxxxxxxxx
> Hey there,
>
> This is the stock code from DMX being a delete record from one table
>
> if ((isset($_GET['recordID'])) && ($_GET['recordID'] != "")) {
>   $deleteSQL = sprintf("DELETE FROM sitedata WHERE siteid=%s",
>                        GetSQLValueString($_GET['recordID'], "int"));
>
>   mysql_select_db($database_bcmain, $bcmain);
>   $Result1 = mysql_query($deleteSQL, $bcmain) or die(mysql_error());
>
>   $deleteGoTo = "index.php";
>   if (isset($_SERVER['QUERY_STRING'])) {
>     $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
>     $deleteGoTo .= $_SERVER['QUERY_STRING'];
>   }
>   header(sprintf("Location: %s", $deleteGoTo));
> }
>
> but how can i make that delete from 3 tables simultaneously?
>
> the other tables being
>
> $deleteSQL = sprintf("DELETE FROM sitedata WHERE siteid=%s",
>                        GetSQLValueString($_GET['recordID'], "int"));
>
> AND
> $deleteSQL = sprintf("DELETE FROM sitecomment WHERE siteid=%s",
>                        GetSQLValueString($_GET['recordID'], "int"));
>
> AND
> $deleteSQL = sprintf("DELETE FROM sitetag WHERE siteid=%s",
>                        GetSQLValueString($_GET['recordID'], "int"));
>
> I hope that makes sense
>
> Thanks
> 



<Prev in Thread] Current Thread [Next in Thread>