我正在尝试一次更新多个列: SET search_page_description='".$id;我明白了:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
目前我有3个帐户是使用相同的电子邮件地址,我想给一个散列关键字相同的电子邮件地址与group by函数。正在运行的sql语句是 SELECT customer_id, email, email_hash FROM customers GROUP BY email) AS t1当我运行这个sql查询时,我得到了这个错误。
所以我只想在PHP中配对用户:mysql_query('SELECT id FROM users WHERE state="0" LIMIT 1');//state 0 = user avaliable, 1 = talking/playing with someone然后更新:
$result= mysql_