Pete, I'll try it out. Thank you very much. I hadn't thought about doing that.
Jer --- In [email protected], Pete <[EMAIL PROTECTED]> wrote: > > In message <[EMAIL PROTECTED]>, whoisquilty > <[EMAIL PROTECTED]> writes > >Any ideas of this? > > > >--- In [email protected], "whoisquilty" <whoisquilty@> 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["product > >ion"].'/'.$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. > > $query=(SELECT photoid > FROM photos > INNER JOIN songs ON songs.songid = photos.song > INNER JOIN productions ON productions.prodid = photos.production > WHERE photoid < $var ORDER BY photoid DESC LIMIT 1) > UNION > (SELECT photoid > FROM photos > INNER JOIN songs ON songs.songid = photos.song > INNER JOIN productions ON productions.prodid = photos.production > WHERE photoid > $var ORDER BY photoid LIMIT 1) > > will give you two records, one for previous photoid, and one for next > photoid. > > Sometimes, it wont (because this is the first photo, or the last photo, > or the only photo) > > (get first record) > if ( photoid < $var ) { > print <a href=... pid=$var>prev</a> > (get next record) > } > if (record read) > print <a href=... pid=$var>next</a> > > ... obviously untested...! > > > -- > Pete Clark > > Sunny Andalucia > http://www.hotcosta.com/comm_1.htm >
