mallen Posted March 16, 2009 Share Posted March 16, 2009 I have this dynamic gallery. It created a table of images. When I click on the image it take it to a detail page and shows the image. I can't get it to display the description. It always displays the first record's decription no matter the image that is showing. It does show the correct image. This is the gallery page: <?php define('COLS', 3); $conn = dbConnect('query'); $sql = 'SELECT * FROM images'; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); $pictureid = $_GET['ID']; $desc = $row['description']; ?> <table> <tr> <?php // initialize cell counter outside loop $pos = 0; do { //// set caption if thumbnail is same as main image if ($row['description'] == $row['description']) { $desc = $row['description']; } ?> <td><p><a href="detail.php?ID=<?php echo $row['ID']; ?>"><img src="images/thumbnails/<?php echo $row['file_name']; ?>" /></a></p></td> <?php // increment counter after next row extracted $pos++; // if at end of row and records remain, insert tags if ($pos%COLS === 0 && is_array($row)) { echo '</tr></tr>'; } }while($row = mysql_fetch_assoc($result)); // end of loop // new loop to fill in final row while ($pos%COLS) { echo '<td> </td>'; $pos++; } ?> </tr> </table> This is the detail page: <?php define('COLS', 3); $conn = dbConnect('query'); $sql = 'SELECT * FROM images'; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); $pictureid = $_GET['ID']; //$desc = $_GET['description']; $desc = $row['description']; $link = $row['url']; <img src="images/fullsize/<?php echo $pictureid; ?><?php echo '.jpg' ?>" /> <?php echo $desc; ?> <?php echo $link; ?> Quote Link to comment https://forums.phpfreaks.com/topic/149718-gallery-display-detail-page/ 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.