Jump to content

Recommended Posts

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; ?>

Link to comment
https://forums.phpfreaks.com/topic/149718-gallery-display-detail-page/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.