SESSIONS and Ordering Databse via Variables

Denkou

Okay I got this to work with the $_GET functions but I want to try and get it to work with Sessions
ALright on one page I have this :

 $hurl = '/JutsuSite/JutsuDB/view.php';
$root = $_SERVER["DOCUMENT_ROOT"].$hurl;
$link =$_GET['link'];
switch($link) {

case 'konoha':
$_SESSION['cat']='Name';
$_SESSION['key']='Konoha';
include($root);
break;

case 'suna':
$_SESSION['cat']='Name';
$_SESSION['key']='Suna';
include($root);
break;

case 'all':
$_SESSION['cat']= FALSE;
$_SESSION['key']= FALSE;
include($root);
break;

default:
include('news.htm');
}
Based on what the 'link' sends to the Script I want it to set certain Values to 'cat' and 'key' Session

then it should go to here:

$s_key=$_SESSION['key'];
$s_cat=$_SESSION['cat'];
echo $s_key;
if(isset($_SESSION['key']))
{
$query = "SELECT * FROM $table_name WHERE $s_cat=\"$s_key\"";
$result= mysql_query($query,$connection);
echo Ss_key;
}
else
{
$query = "SELECT * FROM $table_name ORDER BY Name";
$result= mysql_query($query,$connection);
echo Ss_key;
}

and based on what $_sessions had in it it should order the data by the passed variables
But I dont know why its not working
I dont get any errors but it doesn't sort the data by the passed variables it just displays everythingin the database. So I am assumung that its not passing what I am trying to set in the other script.
Can anyone find out what wrong?

dalecosp

Well, the first question for you is pretty basic ... at what point are you calling [man]session_start/man??

Denkou

ON both pages I call it at the top of the page
along with this line
header("Cache-control: private");

dalecosp

Well, good 🙂

So, next; you are doing some progress checks with [man]echo/man which is good; I assume you can tell where you script is working and track the variables as they are passed around. As to the error, are we to understand that the behavior that you're getting is totally unexpected, or that the script is evaluating isset($_SESSION['key']) to FALSE and taking the "else" every time?

Denkou

I think its the Second of those two situations because the echo doesn't print

Denkou

Alright I Finally Figured it out
The resaon why I was getting no errors was because It was using a different version of the same script which was is a very simlar location as the one I was modifiing

Once I figured that out I finally began getting errors and found out that in an include page a session doesn't need to be started again
And after that it worked
Oh Man this has been plaguing me for days
Finally
thx for whom ever tryed to help. It seems like it was only a problem I could solve on my own

dalecosp

Originally posted by Denkou
Alright I Finally Figured it out
The resaon why I was getting no errors was because It was using a different version of the same script which was is a very simlar location as the one I was modifiing

Once I figured that out I finally began getting errors and found out that in an include page a session doesn't need to be started again
And after that it worked
Oh Man this has been plaguing me for days
Finally
thx for whom ever tryed to help. It seems like it was only a problem I could solve on my own

Well, you're welcome, and don't feel too bad. All of us has a "Doh!" moment every once in a while... 😃