Re: simple query help
| From: | Marek Kilimajer | Date: | Sat, 05 Jul 2003 15:17:07 +0000 |
| Subject: | Re: simple query help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-154057@lists.php.net to get a copy of this message | ||
because you execute the query twice. Remove the last line, it is not needed as UPDATE does not return any result.
Paul Ferrie wrote:
Hi guys,
I am working on a flash forum for my site. Came with the FOED book,
anyways i am tyring to delete the threadCount by -1 from the db.
could below does dlete the count but in multipules of 2.
Anyone
cheers
$query = "UPDATE forumForums SET threadCount = threadCount -1 WHERE forumID
= $forumID";
if(!mysql_query($query)) {
fail("Error deleting thread Count");
}
$result = @mysql_query($query);