jdimino Posted December 13, 2006 Share Posted December 13, 2006 HiI'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>"; ?> Link to comment https://forums.phpfreaks.com/topic/30503-adding-link-to-an-image/ Share on other sites More sharing options...
hitman6003 Posted December 13, 2006 Share Posted December 13, 2006 [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> </td>"; } echo "</tr>";}print "</table>"; [/code] Link to comment https://forums.phpfreaks.com/topic/30503-adding-link-to-an-image/#findComment-140441 Share on other sites More sharing options...
jdimino Posted December 13, 2006 Author Share Posted December 13, 2006 :) :) Thank you, you are Great Link to comment https://forums.phpfreaks.com/topic/30503-adding-link-to-an-image/#findComment-140457 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.