Adding link to an image

[jdimino]

Hi

I'm trying to add a link to the individual image to a set path.+ the image name.
I've tried to add the code, but all I'm getting the same text link (Bloom_Name) how can I change the code? please help

<?PHP

mysql_connect("localhost", "xxxx_xxxx", "xxxx") or die(mysql_error());

mysql_select_db("xxxx_xxx") or die(mysql_error());

$sql = "SELECT * FROM `seedling` ORDER BY `id` DESC LIMIT 25";
$results = mysql_query($sql);

print "<table>";
$column = 1;
while(($row = mysql_fetch_assoc($results)) !== false) {   
if ($column==1) { print "<tr>"; }
print "<td>";
print "<img src=\"http://www.mysite/myfolder/"; 
echo $row['Bloom_Name']; 
    print ".jpg\" width=150 height=150><br>";
    echo $row['Bloom_Name']; 
    print "<a href=\"http://www.mysite/myfolder/cvdata1.php?search=\">Bloom_Name</a><br />\n";
    print "</td>";
if ($column==5) { print "</tr>"; $column=0; }
$column++;
} 
print "</table>";

?>

[hitman6003]

[code]$column = 1;

print "<table>";

while(($row = mysql_fetch_assoc($results)) !== false) {   
if ($column == 1) {
print "<tr>";
}

print '
<td>
<a href="http://www.mysite/myfolder/cvdata1.php?search=' . $row['Bloom_Name'] . '">
<img src="http://www.mysite/myfolder/' . $row['Bloom_Name'] . '.jpg" width="150" height="150" border="0">
</a><br />
' .$row['Bloom_Name'] . '
</td>';

if ($column == 5) {
print "</tr>";
$column = 0;
}

$column++;
}

if ($column < 5) {
while ($column < 5) {
$column++;
echo "
<td>&nbsp;</td>";
}

echo "</tr>";
}

print "</table>"; [/code]

[jdimino]

:) :) Thank you, you are Great