Dynamic link on image?

Hi,

I am trying to add a link to some images but I'm stuck trying to figure out the syntax.

Here is what I've wrote:

<?php
	$query = "SELECT * from products LIMIT 0, 3";
	$result = mysql_query($query) or die(mysql_error());
	echo '<table>';
	echo "<tr>";
	while($row = mysql_fetch_object($result))
	{
		$id = $row->product_ID;
		$picture = substr($row->product_Picture, 3);
		$description = $row->product_Title;
		$price = $row->product_SalePrice;
					
		echo "<td>";
		/********************************
				//HERE IS THE LINK :
		********************************/
		echo "<img src='". $picture ."' href='productpage.php?id=<?php echo $id; ?>' />";
		echo "<br />";
		echo $description;
		echo "<br />";
		echo $price;
		echo "<br />";
		echo "<td>";
	}
	echo "</tr>";
	echo '</table>';
?>

Code (markup):

The images from the query display, but they are not 'clickable'.


I'm trying to make so that if someone clicks on the products image, they will be taken to that products page, but I'm stuck trying to figure out how to form the link.

Can anyone help me with this?

Your help would be most appreciated!

Thanks!

 

echo '<a href="productpage.php?id='.$id.'"><img src="'.$picture.'" /></a>';

PHP:

 

Arr thats brilliant Jay!

Thanks ever so much buddy, really appreciate it!

 

No problem