PHP：SQL查询错误

Question

hello i have a question about some SQL query that keep give me an error
Code :

$result = mysql_query("SELECT email FROM users WHERE user_id='$uid' and set emailchange=1");  

the query keep giving me an error
any help ?

Answer 1

Try following query

$result = mysql_query("SELECT email FROM users WHERE user_id=$uid and emailchange=1");