, 2002 2:52 PM
To: Php-Win (E-mail)
Subject: RE: [PHP-WIN] re: making a DB counter
Try this:
http://www.mysql.com/doc/L/O/LOCK_TABLES.html
That seems to be what you're asking for...
to lock down the table while you select,
then update...
---
Scott Hurring
Systems Programmer
EAC Corporation
[
Message-
> From: Matt Babineau [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 2:41 PM
> To: 'Php-Win (E-mail)'
> Subject: [PHP-WIN] re: making a DB counter
>
>
> Here is a snip of my code
>
> $query = "SELECT Count FROM COUNTER_Page_Views W
Here is a snip of my code
$query = "SELECT Count FROM COUNTER_Page_Views WHERE Counter_ID = '" .
$count_id . "' FOR UPDATE";
$query1 = "UPDATE COUNTER_Page_Views SET Count = Count + 1 WHERE
Counter_ID = '" . $count_id . "'";
$result = mysql_query($query);
$result1 = mysql_query($query1);
what
