A 2nd Products_URL -- not opening in new window

[jerryz]

Per a client request:

I managed to successfully create a second PRODUCTS_URL field called products_url2

mySQL table was updated, and the admin categories.php was also modified.

I created a new product and used the admin to load it in, with the two urls.

I am getting success until the very last part.

I can see both of the product_url links in a product page,
I can see that both of the urls I inserted into the product are showing up in the source code:

---------------------------------------------
THE PROBLEM

Although the first link functions properly, the second product_url link will not open in a new window ... when clicked upon, it opens the homepage of the store, not the link -- HOWEVER the proper link ... in this case "www.yahoo.com" is called in ...


WHAT AM I MISSING !!!

Double Link Test - $1.00

(I have echoed the URLs that are getting called in from the database for help solving this issue



< ! -- CURRENTLY THE CODE FROM THE SAMPLE LINK ABOVE ----

PHP Code:

if (tep_not_null($product_info['products_url'])) {
?>
      <tr>
        <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?> php echo of link --> <?php echo $product_info['products_url']; ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
<?php
    }

< ! -- HERES THE CODE THAT I ADDED ----

PHP Code:

if (tep_not_null($product_info['products_url2'])) {
?>
      <tr>
        <td class="main">
        
        <?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url2']), 'NONSSL', true, false)); ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?> php echo of link --> <?php echo $product_info['products_url2']; ?></td>
      </tr>
<?php
    }

[jpf]

Did you update all the SQL statements for when viewing/searching/adding/updating/deleting products?

There is instruction on adding extra feilds into products - (like ISBN numbers - or in this case a second URL) - Did you follow the instructions?