Add Info from another database???

[joshscott31]

Hello There,

I've spent hours searching forums and google for an answer but can't figure this out at all. I'm trying to add info from a 'master' db of mine such as ingredients, directions, warnings etc to the product_info _display page. This worked on my old oscommerce stores but have since upgraded to zen cart but tying sku from my db to products_model just isn't working. For example sku 89147=products_model 89147. In oscommerce i wrote this:

$mysql_host = "localhost";
$mysql_db = "???";
$mysql_user = "???";
$mysql_pass = "???";

$sku = $product_info['products_model'];

$host1 = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die(mysql_error());
$result1 = mysql_query("SELECT ingredients, directions, warning, ailments FROM wholisti_main.product WHERE sku = '".$sku."'", $host1) or die(mysql_error());

while ($row = mysql_fetch_array($result1)) {
    $ingredients = $row['ingredients'];
    $directions = $row['directions'];
    $warning = $row['warning'];
    $ailments = $row['ailments'];
}
if (!empty($ingredients) ) {
    echo  "";    
}
else {  
    echo  "<br><br><b>Ingredients:</b> ".$ingredients."";
} 

but when inserting this code into zen cart the data was not outputted. i've realized that my problem lies with:

$sku = $product_info['products_model'];

I've tried everything i could think of

$sku = $products_model;
$sku = $product_info['products_model'];
$sku = $products->fields['products_model']; 

to get it to work but with no success. Can you help me?

if you go to http://www.herbshopconnection.com/ch...100-ct-28.html you can see that the word ingredients is showing but the info from my other database.

thanks so much for any help you can give me.

[DrByte]

In what file have you inserted that code?

[joshscott31]

The code i inserted into was in includes/template/CUSTOM/templates/tpl_product_info_display.php

[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?