how to display image as image not as blabla.com/pic.jpg via phpMyadmin & Dreamweaver

[Matt Seigneur]

Hi there

Through gaining valuable info from some tutorials, i've managed to populate a db in phpMyadmin with a deepfeed (it's a big thing for me! )

and also managed to create some record sets so the requested behaviours execute..
only problem is that when i look up the page in firefox it shows the affiliate links like this:
http://www.awin....blabla.htm

And the images like this http://www.asite.com/images/pic.jpg as apposed to the actual image itself!

Would you know

1. how to display the actual image as an image and not the url to the image

2. how to make the aff. deep links "clickable" and not like a long url? maybe the product name and image clickable also/instead of?

[leaddo]

Hi Matt

It sounds to me as though you have forgotten to add <a href="......."> around the aff link and an <img src="...."> around the image text.

Hope this makes sense or am I totally misunderstanding your question?

[mxp]

As leaddo says it sounds like you need to add a couple of html tags to your code. If you want to display the product name rather than the url then you simply need to place the product name within the link tag.

eg.

<a href="url">Productname</a>

if you want to make images clickable you need to enclose them in the link tag.

<a href="url"><img src="imagelocation"></a>

Hope this helps

mxp

[Matt Seigneur]

Ok I tried putting the php tag in a href which is probably complete nonsense, like this:

<a href="<?php echo $row_RsProducts['Link']; ?>"</a>

not suprisingly it didn't work!

I'd like to know how to make the image clickable with the aff. link to open in a new window, and for the image to show up as an image

here's the code i've got:

PHP Code:

<?php } while ($row_RsProducts = mysql_fetch_assoc($RsProducts)); ?>              
 </span></p>           </td>          
<td width="293" valign="top"><p class="style3">
<?php echo $row_RsProducts['Cost']; ?></p>
           <p class="style3"><?php $_GET['Link']; ?>
<?php echo $row_RsProducts['Link']; ?>
<?php echo $row_RsProducts['Image']; ?></p></td>        
  <td width="293" valign="top"><span class="style3">
<?php echo "$row_RsProducts['Link']"; ?></span></td>

[andy_jacko]

heres a sample from my site.

HTH

regards andy

PHP Code:

<a href="<?php echo $row_Recordset1['deepLink']; ?>" target="_blank" <img src="<?php echo $row_Recordset1['imageURL']; ?>"></a>

[Matt Seigneur]

Thanks Andy and others I used your code and edited it slightly, as it wasn't displaying properly:

PHP Code:

<a href="<?php echo $row_RsProducts['Link']; ?>" target="_blank">
<?php echo $row_RsProducts['ProdName']; ?></a><a href="<?php echo $row_RsProducts['Link']; ?>" target="_blank">
<img src="<?php echo $row_RsProducts['Image']; ?>" 
border="0" /></a><a href="<?php echo $row_RsProducts['Link']; ?>"></a>&nbsp;

now working fine!