Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

need help with tep_db_query update


Recommended Posts

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



assuming affiliate_id is a variable, try this:


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




addicted to writing code ... can't get enough of databases either, LOL!


my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum


Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites


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

  • Create New...