select record using $_GET or nothing

f8ball

I'm not sure how to search for this question so please pardon if a similar post is floating out here.

I'm building a gallery and I need to build in the option to go forward and back between photos. That's not a problem. The problem is if someone selects a specific photo then I'm not sure how to set it up. Would that be a select statement I need to use?

So if someone select photo ?id=3 there'd be navigation links below the photo .. if they just jumped right into a gallery there'd be no ?id= .. does that make sense? Thanks for any advice.

bpat1434

Read my tutorial, might help you. I wrote in some "pagination" code to do exactly what you want to do.

Articles link in sig...

~Brett

f8ball

Thanks, but that's not really what I'm after. I've set up a CMS site for a client of mine so all the photos are dynamic and info is pulled from the DB.

I tried to write something similar to what you use to check the variable, but that didn't work ..

if (!(isset($_GET['view']))){
$getthis = "$query_rsFullSize = sprintf(\"SELECT * FROM photos WHERE pid = %s\", $colname_rsFullSize);";
$colname_rsFullSize = "-1";
if (isset($_GET['pid'])) {
  $colname_rsFullSize = (get_magic_quotes_gpc()) ? $_GET['pid'] : addslashes($_GET['pid']);
}
} else {
$getthis = "$query_rsFullSize = \"SELECT * FROM photos ORDER BY p_dorder ASC\";";

bpat1434

SO, if the user gets pic id=7, then:

$prev = $_GET['pid']-1;
$next = $_GET['pid']+1;

Now, determining whether or not the pictures are there is a different story.

f8ball

Yeah, see that's a problem because some id's wouldn't exist if the photos are deleted. I'm wondering if I can do something like:

"SELECT * FROM photos ORDER BY p_dorder ASC"

Normally .. you'd have SELECT * FROM photos WHERE to select the specific photo .. I'm wondering if you can select the image based on the order somehow .. so if the photo id is 9 just say .. it would sort them so 9 is first (showing) and then use a loop to go to the next record.

bpat1434

Well you see, that's when array functions come in handy. Take the results, put them in an array, and then just [man]array_search[/man] for that ID, and then use that to get the previous and next records....