problem passing variables using frames

skdzines

I am lost as to why this thing is not working. I am creating a database for a band to list their shows and pictures from each show. I have a page called shows.php which dynamically lists all of the shows in the database and assigns a variable called $showID to be passed along to the next page. This thumbs.php page will pull the thumbnail images according to the $showID. From there if you click on a thumbnail it will call the page imageDisplay.php which will display the correct image from that show according to its $showID and $picID.

All of this works fine until I include the thumbs.php and imageDisplay.php into a frameset page called pics.php. It is basically setup kind of like your images folder in Windows when you view it in Thumbnail View.

Anyway can anyone tell me why this doesn't work when I use the frame?

Below is some of the code:

shows.php

 <?  

  $sql = "SELECT showID, date 
		FROM shows ORDER BY showID ASC";
  $res = mysql_query($sql); 
while($show = mysql_fetch_array($res)) {

echo"
<tr>
    <td>
	 <a href='http://66.195.17.117/~movingto/pics.php?showID=".$show['showID']."'>".$show['date']."</a>
	</td></tr>";
	}
	?>

pics.php //this is the frame page

<?
session_start();
$showID = $_GET['showID'];
$_SESSION['showID'] = $showID;
?>

thumbs.php

session_start();
$showID = $_GET['showID'];
$_SESSION['showID'] = $showID;

$sql = "SELECT *
        FROM images WHERE showID = ".$showID.""; 

$res = mysql_query($sql); 
while($image = mysql_fetch_array($res)) {

   echo ("
    <td width='75' height='50'><a href='http://66.195.17.117/~movingto/imageDisplay.php?id=".$image['id']."' target='display'><img src='http://66.195.17.117/~movingto/pics/".$image['location']."/".$image['thumb'].".".$image['ext']."' width='75' height='50' border='0'></a></td><td width='25'></td>
    ");
}

imageDisplay.php

session_start();
$_SESSION['showID'];
$id= $_GET['id'];

if(!isset($id)){
	$sql = "SELECT id 
        FROM images WHERE showID = ".$_SESSION['showID']." ORDER BY ASC";

	$res = mysql_fetch_array(mysql_query($sql));

	$id = $res[0]; 

	$sql2 = "SELECT location, pic, ext 
			FROM images WHERE showID = ".$_SESSION['showID']." AND id = ".$id."";

	$res = mysql_fetch_array(mysql_query($sql2));
}else{
	$sql = "SELECT id, location, pic, ext 
        FROM images WHERE showID = ".$_SESSION['showID']." AND id = ".$id."";

	$res = mysql_fetch_array(mysql_query($sql)); 
}

<img src='http://66.195.17.117/~movingto/pics/".$res['location']."/".$res['pic'].".".$res['ext']."'>

Thanks for your help in advance.

skdzines

Does anybody know how I can accomplish this using frames? Like I said, this whole thing works if I don't call the frames page. But unfortunately the customer wants it set up with frames.

Thanks

Weedpacket

Just as a wild guess, perhaps have the frameset start the session. My thinking is this: In your current setup

The frameset loads
The client parses the frameset and requests all of its frames
The server receives a bunch of requests
The session hasn't been started yet, so it's got no reason to assume these requests are all from the same client. It assigns different session IDs to each one.
The client receives the responses, along with all of these session IDs.
The last one it receives overwrites all of the others.
The other frames have to wait until they're refreshed again before the client sends the right session ID. Any session data already set in the other sessions is lost.

That's just a guess: since I'm not the one in a position to test this (you are), that's all it can be. But if the guess is right, then a solution would be to set the session ID in the enclosing frameset; then the client will already have a single session ID to supply with its requests for the frames.

I am of course assuming that your server is indeed at 66.195.17.117, and is always identified as 66.195.17.117 - if the client doesn't think the host it's sending a request to is the same one that sent the session ID in the first place, the session ID won't be sent.

skdzines

Thanks for the reply weedpacket. From the following code which is calling the frames page and sending the showID

<a href='http://66.195.17.117/~movingto/pics.php?showID=".$show['showID']."'>".$show['date']."</a>

Isn't the session being started in the frames page by the following code?

<? 
session_start(); 
$showID = $_GET['showID']; 
$_SESSION['showID'] = $showID; 
?>

And right now I am just using the IP address temporarily until they have the actual domain set up on the server.

Thanks

jannoy

in your frame
must have a name
like
<frame name="blah">

and in your <a href="whateverthelinkis">test</a>

add

your target is the name of your frame

skdzines

Thanks for your help guys. I have come up with a different way to accomplish this. However this new way raises a new question. How can I call 2 different pages with the same href? I need to have the href call thumbs.php target='thumbs' and imageDisplay.php target='display' into the frameset.

Thanks again.

Kudose

I am rather curious to see if someone can produce a way to accomplish what you just asked.

jannoy

one href two frame??
something like this

http://www.dazzlejewelers.com

skdzines

right now I have a frameset with a frame on the left, a fixed bottom frame and then a frame in the middle which takes up the rest of the frameset. I want to have an a href in the left frame call the page to be loaded in the bottom frame 'thumbs' and call the page to be loaded in the middle frame 'display'.

Thanks