Why does this query not work using mysql 3.23.58?
The query is updating all records with no regards to the WHERE clauses.
Do I need to do separate updates for each WHERE clause?
$SQL =<<SQL;
UPDATE $tablename SET rank = '$qdj_rank_en', rank_icon = '$qdj_rank_icon', qdj
= qdj+'$adata{qdj_credit}', gold = gold+'$adata{gold_credit}' WHERE subscribe
!= '' OR artist = '1' OR rank_change != '1'
SQL
$dbh->do($SQL) || &cgierr("Reason: $!");
--
Bruce Therrien <[EMAIL PROTECTED]>
This is the end of the internet.
Please turn around and go back.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
