RE: [PHP] Selecting what's for deletion
| From: | John W. Holmes | Date: | Fri, 27 Dec 2002 11:31:55 +0000 |
| Subject: | RE: [PHP] Selecting what's for deletion | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129423@lists.php.net to get a copy of this message | ||
> Thanks John and Marek for your fast responses. I made the decision to
> opt for the "hidden" tag option. Now, I'll show you the part of my
code
> that hangs when trying to make what I intend it to do.
>
> ========================
>
> $query1 = "DELETE * FROM maracat WHERE catid = $catid";
> $result1 = mysql_query($query1) or die (mysql_errno());
>
> $query2 = "DELETE * FROM marasubcat WHERE catid = $catid";
> $result2 = mysql_query($query2) or die (mysql_errno());
>
> $query3 = "DELETE * FROM maraprod WHERE catid = $catid";
> $result3 = mysql_query($query3) or die (mysql_errno());
>
> echo "Accion taken<br>";
> echo "<a href=\"cat.php\" class=\"link2\">Back</a>";
>
> ========================
>
> I know that it's very tedious to write 1 query for each action taking
> place, but I think this is easier for me to change in the future. Now,
> the page gets stuck when reaching this level and doesn't process what
I
> ordered... Any thoughts? Thanks in advance,
Do you get an errorno() or does it just not delete? It's better to echo
mysql_error() along with mysql_errno() in your die() statement.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/