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'";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
