need help with tep_db_query update

[frank1002us]

hi folks

i need to change the email address of all my affiliates to [email protected]

is there a code that i can do this in one shot

i was trying

tep_db_query("update " . TABLE_AFFILIATE . " set affiliate_email_address = affiliate_id"."'@mysite.com'");

but it does not work i get syntax error

[♥Monika in Germany]

hi folks

i need to change the email address of all my affiliates to  [email protected]

is there a code that i can do this in one shot

i was trying

tep_db_query("update " . TABLE_AFFILIATE . " set affiliate_email_address = affiliate_id"."'@mysite.com'");

but it does not work i get syntax error

<{POST_SNAPBACK}>

 

 

assuming affiliate_id is a variable, try this:

 

tep_db_query("update " . TABLE_AFFILIATE . " set affiliate_email_address = '" . affiliate_id . "@mysite.com'");

[frank1002us]

thankyou