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>"; ?> Quote Link to comment 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] Quote Link to comment Share on other sites More sharing options...
jdimino Posted December 13, 2006 Author Share Posted December 13, 2006 :) :) Thank you, you are Great Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.