Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Using multiple databases - how to select each? {help}


smartwork

Recommended Posts

I've separated an OSC shop to use two databases: one for product-oriented info, and one for customer/order oriented info. During the order placement, the function

tep_db_insert_id() is used in checkout_process.php, but is not working successfully. Even though it directly follows the query that should allow it to use the correct database (the way I understand it), I believe it may not be. This results in zero instead of the correct value.

 

 

   tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
   $order_products_id = tep_db_insert_id();

 

Can anyone offer some direction to properly select the correct database? I've tried with passing $link in the function, but have not had success.

 

Thanks!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...