fbsd_user wrote:
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1' is not coded correctly, but I get no errors so can not tell.

Anybody have any ideas?

The table def has   count_of_logons     INT,

$sql = "UPDATE members SET count_of_logons = 'count_of_logons + 1' WHERE logon_id = '$logonid' AND logon_pw = '$logonpw'
         AND email_verified = 'Y'";


Why are you quoting 'count_of_logons + 1'? In any case, that's the problem. 'count_of_logons + 1' is a string. You are assigning it to an INT, so it must be converted to a number. Strings which do not start with anything numeric convert to 0. For example:

mysql> SELECT 'count_of_logons + 1' + 0;
+---------------------------+
| 'count_of_logons + 1' + 0 |
+---------------------------+
|                         0 |
+---------------------------+
1 row in set (0.00 sec)

Leave out the quotes to get the expected result:

  $sql = "UPDATE members
           SET count_of_logons = count_of_logons + 1
           WHERE logon_id  = '$logonid'
             AND logon_pw    = '$logonpw'
             AND email_verified = 'Y'";

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to