health_html/inc/newsDelete.php

<?php
        function newsDelete($id) {
                if (!$id) return;
                global $dbh, $syspicdir;
                $sql = "SELECT pic FROM paragraphs WHERE (news_id = $id)";
                $sth = $dbh->prepare($sql);
                if (!$sth) error("Cannot prepare query: \"$sql\"");
                if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
                while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]);
                $sth->finish();
                $sql = "DELETE FROM related WHERE (news_id = $id)";
                $dbh->dbh_do($sql);
                $sql = "DELETE FROM paragraphs WHERE (news_id = $id)";
                $dbh->dbh_do($sql);
                $sql = "SELECT title_pic FROM news WHERE (news_id = $id)";
                $sth = $dbh->prepare($sql);
                if (!$sth) error("Cannot prepare query: \"$sql\"");
                if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
                while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]);
                $sth->finish();
                $sql = "DELETE FROM cat_news WHERE (news_id = $id)";
                $dbh->dbh_do($sql);
                $sql = "DELETE FROM spec_news WHERE (news_id = $id)";
                $dbh->dbh_do($sql);
                $sql = "DELETE FROM news WHERE (news_id = $id)";
                $dbh->dbh_do($sql);
        }
?>
1	ravilov	1.1	<?php
2			function newsDelete($id) {
3			if (!$id) return;
4			global $dbh, $syspicdir;
5			$sql = "SELECT pic FROM paragraphs WHERE (news_id = $id)";
6			$sth = $dbh->prepare($sql);
7			if (!$sth) error("Cannot prepare query: \"$sql\"");
8			if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
9			while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]);
10			$sth->finish();
11	ravilov	1.3	$sql = "DELETE FROM related WHERE (news_id = $id)";
12			$dbh->dbh_do($sql);
13	ravilov	1.1	$sql = "DELETE FROM paragraphs WHERE (news_id = $id)";
14			$dbh->dbh_do($sql);
15			$sql = "SELECT title_pic FROM news WHERE (news_id = $id)";
16			$sth = $dbh->prepare($sql);
17			if (!$sth) error("Cannot prepare query: \"$sql\"");
18			if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
19			while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]);
20			$sth->finish();
21	ravilov	1.2	$sql = "DELETE FROM cat_news WHERE (news_id = $id)";
22			$dbh->dbh_do($sql);
23			$sql = "DELETE FROM spec_news WHERE (news_id = $id)";
24			$dbh->dbh_do($sql);
25	ravilov	1.1	$sql = "DELETE FROM news WHERE (news_id = $id)";
26			$dbh->dbh_do($sql);
27			}
28			?>