Query creates Syntax error

[johnlanglois]

I hope this is the right place to ask this question.

I need to update some NULL fields that were accidentally introduced in a table. I have pulled the users' email addresses with a recordset from the users table and want to update them in the table.

The query for the update is :

$query_repair = "UPDATE tickets SET tickets.user_email = {$row_rsUsers['user_email']} WHERE tickets.UserID = {$row_rsUsers['id_usr']}";

When printed out the query resolves as follows:

UPDATE tickets SET tickets.user_email = [e-mail] WHERE tickets.UserID = 1

However, when passed to MySQl I get:

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 '@.net WHERE tickets.UserID = 1' at line 1

It seems to be choking on the user's email address at the @ sign.
Do I need to enclose this another way?

Thanks.

[bradgrafelman]

Strings in MySQL queries, just like in PHP, need to be quoted, so try surrounding the email address in single quotes.

[bradgrafelman]

Also, does the user_email field always correspond to a column in the users table? If so, why duplicate the data in the tickets table as well?

[johnlanglois]

I tried placing the recordset info inside quotes, but it choked down as a syntax error, so I am still working on saying it the MySQL wants to hear it.

I appreciate the note on the email field redundancy. That is actually by design because that table also serves as an audit trail.

Thanks for the help.

[bradgrafelman]

johnlanglois wrote:

I tried placing the recordset info inside quotes, but it choked down as a syntax error

Can you show us what you tried?