Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

why wont this line parse ?


Guest

Recommended Posts

$set_table = "[affiliate_sales]";

 

tep_db_query("update "$set_table" set affiliate_payment = TRUNCATE(80/100 * affiliate_value,2) WHERE affiliate_payment=''");

 

what am i missing here? i keep getting parse error

Link to comment
Share on other sites

tep_db_query("update "$set_table" set affiliate_payment = TRUNCATE(80/100 * affiliate_value,2) WHERE affiliate_payment=''");

 

It's the quotes around $set_table.. To keep the exact same line you have above, you will need to change it to:

tep_db_query("update \"$set_table\" set affiliate_payment = TRUNCATE(80/100 * affiliate_value,2) WHERE affiliate_payment=''");

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...