Add Info from another database???

[DrByte]

You'll see in that file that the product model number is contained in the $products_model variable:

  <?php echo (($flag_show_product_info_model == 1 and $products_model !='') ? '<li>' . TEXT_PRODUCT_MODEL . $products_model . '</li>' : '') . "\n"; ?>

[joshscott31]

Thanks DrByte,
I did notice that and one of the 1st things i tried was $sku = $products_model; but it didn't work.

[DrByte]

So, when you echo out the value of $products_model, what does it give you?
And, is the products_model field populated for that product in your database?

[joshscott31]

Yes all of the products in my main database have sku's that are the exact same as the products_model. If i echo out the $sku = $products_model line then i don't see the word Ingredient and of course i still do not see any data from the other database. For a working example you can go to:

http://www.lifebalm.com/herbal-produ...a-Capsule.html

of course this is oscommerce which i'm trying to get away from and use only zen cart but you can see the ailments, ingredients etc.. are shown from my other database.

Now on http://www.herbshopconnection.com/ch...100-ct-28.html

you will see that only the word ingredients show.
AAh???

thanks again Dr Byte for your continual help.

[DrByte]

And what happens if you use this:

 $sku = '89147';

[joshscott31]

Hello Dr Byte,
That still didn't work which surprised me so i looked hard at the code and realized i have the if/else backwards. So i switched that and changed the coding back to $sku = $products_model; and it worked perfectly. Too many hours for such a stupid mistake on my part. Thanks so much for your help. You are great.

Josh

[time111]

Hi,

Please can anybody say me where to place $sku = $products_model; in tpl_product_info_display.php. So that in Place of Model it shows SKU.

I need the complete replacement code line.

thanks.

~ Time