Page refresh and passing variables in the url location. Help needed.

vryce

Okay, this code is long and I apolgize for that. I didn't post my
entire page code, but I think this is the important part where my
problem(s) is/are.

Its a strange problem because my page works about 85% as
expected.

If you go to this page and follow along.

Once the page is up, if you click on any of the links:

The page behaves normally. You can click on say Want list and
then VHS list and it displays the page correctly(correct query
behind the scenes. I had it echo the query for me when I was
testing the page.) and the url has the correct variables in.

Now, if you start from the default page(no variables passed in
the url line) and click on a Genre, say Action, it displays correctly
with the correct query and variables listed in the url.

Now, the problem becomes when you click on a Region, it doesn't
display as it should, the query is wrong, but the correct variables
are listed in the url.

The problem seems that depending on which selections I make,
I'm losing variables in the script, even though the url has them
showing correctly.

It gets even stranger in that if I start from the main page, choose
a Region or a genre, and one of the links: Viewing all format
Movie list | Go to DVD only list | Go to VHS only list | Go to
LaserDisc list, the page doesn't display correctly and seems to
lose variables. But, if you choose a region or genre and one of
the top links: Go to Owned list | Viewing Want list | Go to On
Loan list | Go to For Sale list | Go to On Order list, everything is A-
ok.

I hope this made sense and this problem has been driving me
nuts for a while.

If anyone needs to see the full code, let me know and I can
provide that.

This code is at the top of my page:


$Category = $_GET['Category'];
$MediaFormat = $_GET['MediaFormat'];
$Genre = $_GET['Genre'];
$Region = $_GET['Region'];


$Category = (($Category) ? $Category : 'Own');
$MediaFormat = (($MediaFormat) ? $MediaFormat : 'All');
$Genre = (($Genre) ? $Genre : 'All');
$direction = (($direction) ? $direction : 'ASC');
$Region = (($Region) ? $Region : 'All');

vryce

It looks like my variables are being lost when the page reloads, though not all the time.

I put a bunch of echos in to echo out my variable contents.

Why would a sql query cause variables to be reset?

Its probably something silly I did that is causing my problem, but I've been struggling with it for a long time now.

If anyone that would like to help needs to see the whole php code, let me know and I can get you a link to the code so you can view it.

kevinsequeira

:eek: well i had quite a time figuring what the issue was 😃 , could u post the code or the link

reg
kevin

vryce

Sure... I had posted previously a couple of code snippets that were quite long. I guess they were intimidating and very long that I didn't have any replies. I deleted them and shortened my thread post.

Here is the link to the php code

Code

Currently, the code is very sloppy and has many unecessary things in it. I want to get it working like I need before I go back and clean up the code.

Thanks for the reply and in advance for any help or pointers you can give.

kevinsequeira

well i would probably re-write the entire search / query part, but lets get to that later, for now could u echo the query on the page ??

reg
kevin

vryce

K... echo of query right before the table displays.

kevinsequeira

well see you're current query, it doesnt pick up region value
http://www.solitaryspaces.com/dvdtrack/dvdtrack.php?Category=Own&MediaFormat=DVD&Genre=All&Region=6

try this snippet for your query

$countquery = "select count(ID) as TotalMovies, SUM(Discs) As TotalDiscs from dvd where OkToDisplay != 'No'";
if($MediaFormat =="All"){
	$media_where = "";
}else{
	$media_where = " AND MediaFormat = '".$MediaFormat."'";
}
if($Genre =="All"){
	$genre_where = "";
}else{
	$genre_where = " AND Genre = '".$Genre."'";
}
if($Region =="All"){
	$region_where = "";
}else{
	$region_where = " AND Region = '".$Region."'";
}	
$countquery = $countquery.$media_where.$genre_where.$region_where;
echo $counquery;

u get the idea how to shorten the code for the query...

reg
kevin

vryce

Nice... I didn't even think that the count query not having the Region in it would cause problems.

I added your code and it now keeps the Variables straight. It looks like I now just need to work on my logic in the main query portion.

I think that you helped resolve the biggest concern. I will keep you posted so that once it is finished, you can see.

Thank you very much for taking the time to help out so far. It is truly appreceiated. 🙂

kevinsequeira

no problem, i just noticed that i didnt add the filter for category in the query, so just change this
$countquery = "select count(ID) as TotalMovies, SUM(Discs) As TotalDiscs from dvd where OkToDisplay != 'No'";
to
$countquery = "select count(ID) as TotalMovies, SUM(Discs) As TotalDiscs from dvd where OkToDisplay != 'No' AND Category='".$Category."'";

vryce

Thanks.

And now my page is working perfectly.

I forgot to delete the complex query code I had for the main query.

So I was setting the query using your code and then resetting it using my old code. I deleted that old code and it works great.

Thank you again for your help.