[kpowers4]

I need help adding Hyper Links to my PHP (array generated) short text descriptions. Id like the link to reference a file that has a long text description, the hyper link should open up another window.

Any help or tips would be helpfull!!

Here is the php code that displays the descriptions (text) from my MySQL database:


PHP Code:

PHP Code:

 for($i=$n_start;$i<=$n_end;$i++) 

 {  

    echo "<tr>"; 

    echo "<td align='center'> 

                 {$products[$i]['catalog_number']}</td>\n"; 

    echo "<td>{$products[$i]['description']}</td>\n"; 

    echo "<td>\${$products[$i]['price']} </td>\n"; 

    echo "<td><img src='images/{$products[$i]['pix']}'></td> \n";  

    echo "</tr>"; 

 } 

[mab]

If you literally want this long description to be contained in a file, there are two ways to add a link.

The 1st way, a field with a file name is added to your database for each product, something like - $products[$i]['longdescription'] This can then be used to form the link.

The 2nd way, if you cannot or don't want to modify your database tables, would be to use the $products[$i]['catalog_number'] to form the file name in the link. This assumes that your catalog numbers can all be used as file names.

For the 1st way, the complete file name with a .txt or .html extension (or whatever you want) would be stored in the database. For the 2nd way, a .txt or .html would need to be added to the catalog number part to form the file name.

In ether case, the existing short description in the table would be changed. You can either change it entirely into a link or add a link to part of it.

To change the entire short description into a link -

PHP Code:

echo "<td><a target='_blank' href='what file to open goes here'>{$products[$i]['description']}</a></td>\n"; 

To add something like "more info..." as a link onto the end of the short description -

PHP Code:

echo "<td>{$products[$i]['description']}<a target='_blank' href='what file to open goes here'>more info...</a></td>\n"; 

[kpowers4]

Hey thanks again!! You gave me a great solution. I stuck with option #1 and added the link (to the text) in my database. Then i just echo it back out with the line of text. The code for anyone else looks like this:

PHP Code:
echo "<td><a target='_blank' href={$products[$i]['link']}>{$products[$i]['description']}</a></td>\n";