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 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			$sql = "DELETE FROM paragraphs WHERE (news_id = $id)";
12			$dbh->dbh_do($sql);
13			$sql = "SELECT title_pic FROM news WHERE (news_id = $id)";
14			$sth = $dbh->prepare($sql);
15			if (!$sth) error("Cannot prepare query: \"$sql\"");
16			if (!$sth->execute()) error("Cannot execute query: \"$sql\"");
17			while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]);
18			$sth->finish();
19	ravilov	1.2	$sql = "DELETE FROM cat_news WHERE (news_id = $id)";
20			$dbh->dbh_do($sql);
21			$sql = "DELETE FROM spec_news WHERE (news_id = $id)";
22			$dbh->dbh_do($sql);
23	ravilov	1.1	$sql = "DELETE FROM news WHERE (news_id = $id)";
24			$dbh->dbh_do($sql);
25			}
26			?>