Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

need help with tep_db_query update


frank1002us

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'");

:-)

Monika

 

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

Archived

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

×
×
  • Create New...