Tyring to create an image link where source url and link is in database.

[oriental_express]

Hi

 

I've got this database I created with fields

 

ProductId  ProductName  Image

 

I've managed to get it to list the ID,productname, and Image urls

in a list.

 

My next step is to have the image field actually display

an image and make it clickable:

 

heres what I've done so far:

 

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("productfeed", $con);

$result = mysql_query("SELECT * FROM productfeeds");

echo 
"<table border='0'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Image</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";
  echo "<td>" . $row['ImageURL'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

 

Heres what I want to do:

 

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";

// my changes beneath
  echo "<td>" . <a href="<?php echo $row['ImageURL'];?>"> <img src="<?php echo $row['LinkURL']; ?>"> </a>. "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

 

Can you guys point me in the right direction?

 

Many thanks

 

[Muddy_Funster]

where are you getting $row['LinkURL'] from?

[oriental_express]

where are you getting $row['LinkURL'] from?

 

Hi there

 

I'm not sure I suppose what I'm trying to do with LinkURL is to make the image clickable?

All other areas has $rows so I thought I would try it.

 

is it possible to have a href link inbetween an echo function?

 

Where am I going wrong ?

 

 

[Muddy_Funster]

if it is the full URL for the immage that is stored in the database then all you need is:

echo "<td><a href='{$row['ImageURL']}'> <img src='{$row['ImageURL']}'> </a></td>";

this will take you to the image, replace the value for href= if you want to go some place else.

[oriental_express]

if it is the full URL for the immage that is stored in the database then all you need is:

echo "<td><a href='{$row['ImageURL']}'> <img src='{$row['ImageURL']}'> </a></td>";

this will take you to the image, replace the value for href= if you want to go some place else.

 

Thank you very much It now works.

[Muddy_Funster]

you are very welcome