Jump to content

SQL Syntax Error


compsci

Recommended Posts

Hello all,

 

I have been mulling over this for like an hour now and am frustrated. I bet also the solution is very simple.  :P Please help.

 

This is my sql query using PHP:

 

$email = $_GET['email'];

$query = sprintf("UPDATE members SET verified = '1' WHERE userName = $email");

mysql_query($query) or die(mysql_error());

 

I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE username='[email protected]'' at line 1

 

-->Verified is a tiny int - can this be a problem?

 

What is the probelm??  :confused:

 

The above is a simple email activation of an account.

 

Thanks :)

Link to comment
https://forums.phpfreaks.com/topic/97523-sql-syntax-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.