RE: [PHP] simple query help
| From: | Giz | Date: | Sat, 05 Jul 2003 23:40:34 +0000 |
| Subject: | RE: [PHP] simple query help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-154089@lists.php.net to get a copy of this message | ||
Bleh nevermind, it's because you were executing the query twice (calling
mysql_query in the if () and then again below.
-----Original Message-----
From: Giz [mailto:gizmo@gizmola.com]
Sent: Saturday, July 05, 2003 4:37 PM
To: 'Paul Ferrie'; php-general@lists.php.net
Subject: RE: [PHP] simple query help
My guess is that you actually have 2 rows in the table for every forumID.
-----Original Message-----
From: Paul Ferrie [mailto:info@innovativedesigns.org.uk]
Sent: Saturday, July 05, 2003 8:07 AM
To: php-general@lists.php.net
Subject: [PHP] simple query help
$query = "UPDATE forumForums SET threadCount = threadCount -1 WHERE forumID
= $forumID";
if(!mysql_query($query)) {
fail("Error deleting thread Count");
}
$result = @mysql_query($query);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php