I can see something that can be the problem, in mysql 3 you don´t have trigger, then you cannot use trigger_error function, try to use mysql_error instead.
""Nicholas Vettese"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] I have a registration script that inserts data into the database, and then emails you an activation code to activate your account. The problem is that when I click on the link in the email, the account does not get updated. The portion of the script that has a problem is this: $query = "UPDATE users SET active=NULL WHERE user_id=$x AND active='" . escape_data($y) . "' LIMIT 1"; $result = mysql_query ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error()); I do not believe this is a PHP problem because the error states that it is most likely a MySQL error. If anyone can see the problem, can you please let me know what it is. I have been looking at this for about three days now, and I can't figure it out. The registration page does update the DB (MySQL 3.24.49), but the activation page does not. Thank you, Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
