All Manufacturers - I need help adding url to page...

[oscrazy]

RE: http://www.oscommerce.com/community/contri...ll+manufacturer

 

Great Contribution-can anyone help me find what I need to change to make a link to the manufacturer's page under their logo? If I'm not mistaken, the url is in a seperate table and I have been racking my brain for days on this, so any help is appreciated :D

 

Current code:

 

<?php

$manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_id, manufacturers_image from " . TABLE_MANUFACTURERS . " order by manufacturers_name" );

 

if (tep_db_num_rows($manufacturers_query) >= '1') {

while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {

 

echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '=' . $manufacturers['manufacturers_name'], 'NONSSL', false) . '">'. $manufacturers['manufacturers_name'] . ' <br> ' . tep_image(DIR_WS_IMAGES . $manufacturers['manufacturers_image'], $manufacturers['manufacturers_name']) . "</a><br><br>\n";

}

}

?>

 

This makes an out put like:

 

Company Name (Linking to their products in my store)

Company Logo (Linking to their products in my store)

 

But what I want is:

 

Company Name (Linking to their products in my store)

Company Logo (Linking to their products in my store)

Click to learn more... (Linking to their url that I entered when entering them as a manufacturer in the admin)

 

 

Any suggestiongs ??