Any ideas of this?
--- In [email protected], "whoisquilty" <[EMAIL PROTECTED]> wrote:
>
> Here is the full query to the MySQL database:
>
> $photoquery = "SELECT *
> FROM photos
> INNER JOIN songs ON songs.songid = photos.song
> INNER JOIN productions ON productions.prodid =
> photos.production
> WHERE photoid = $var";
> $photoresult = mysql_query($photoquery) or die(mysql_error());
> $photorows = mysql_num_rows($photoresult);
>
> while ($photo = mysql_fetch_array($photoresult))
> {
> print '<table width="64" border="0" cellspacing="0" cellpadding="5">
> <tr>
> <td>';
>
> print '<img
> src="../../gallery/'.$photo["production"].'/'.$photo
> ["file"].'" border="0">';
>
> print '</td>
> </tr>
> <tr>
> <td>'.$photo["caption"];
>
> if(!empty($photo["thanks"]))
> {
> print ' <i>(Thank you to '.$photo["thanks"].' for this image)</i>';
> }
>
> print ' </td>
> </tr>
> </table>';
> }
>
>
> I've got a thumbnails page that people choose which photos they want to see
> full views
of.
> The photos are categorized by song and also categorized by production. Only
> the
photos
> from a certain production show up on a thumbnail page. So, on the thumbnail
> page, the
> thumbnails from the chosen production show up categorized by song. Each photo
> has a
> sort number to keep them in a specific order.
>
> I want users to have the option of viewing thumbnails individually, or
> cycling through
> them on the full photo page that each thumbnail is linked to. This would mean
> starting
at
> the photo that they click on a thumbnail, taking them to the full photo page,
> and links
on
> the full photo page allowing them to move to the next photo in the sequence
> (if they
come
> into the sequence at a photo whose sort number is 5, they should be able to
> move
forward
> to 6 and backward to 4 without going back to the thumbnail page).
>
> So, the next/previous links need to stay within the confines of the specific
> production
and
> specific song that they are designated as.
>
> Sorry I was unclear...again.
>
