[truesilentassassin]

Hello,

I have a page called city.php which displays a list of major cities based on the state selected. I have an index.html page which has all the state names with links like city.php?state=California, city.php?state=Texas, and so on.

Since the link is setup this way, I am able to query for the user selected state by using state = '{$_GET['state']}'

Using $_GET I am able to display cities based on the state clicked by user.

I have a page called category.php and I do the same thing.

I list categories based on city clicked, the problem here is all cities have the same categories (about 40 categories) so all I do on this page is select * from category;

On this page I give link for each category as: categorydetails.php?category=Automobile and so on.

Doing this, I am able to display details on the category selected by user.

But my selection is based on the category (using $_GET)

I also want to use city in my query.

What I mean is: I want to display categories for the category selected by the user in category.php page and ONLY FOR THE CITY SELECTED BY THE USER IN THE CITY.PHP page.

This is where I have trouble.

I don't have the city value stored anywhere to use it on categorydetails.php page.

I am able to use city on the category.php page using $_GET, but not on categorydetails.php page.

Is there a way that I could use the value of city from the category.php page in my categorydetails.php query page?

Now the link for each category is setup like this: categorydetails.php?category=$category

I also tried:
categorydetails.php?category=$category&city=$city

and used city in my query in categorydetails.php page, but I dont get any results nor errors.

Please help me.

Regards,

[jasong]

Couldnt you use hidden fields in category.php?

[truesilentassassin]

Hello,
Here is my situation:

I have a page called category and I pull several categories from my database.

Each category is linked this way:

categorydetails.php?category=$category&city=$city

$category and $city is taken using $_GET

The script perfectly works for categories and cities with a name without space.

What I mean is, if I select Sacramento, the query works well.

If I select Los Angeles, my link looks like this:
categorydetails.php?category=Automobile&city=Los

It excludes "Angeles". I am assuming it has to do something with the space in the middle.

How do I over come this.

I link should actually look like this:
categorydetails.php?category=Automobile&city=Los Angeles.

Help me.

Regards,

[truesilentassassin]

Hello,
Here is my situation:

I have a page called category and I pull several categories from my database.

Each category is linked this way:

categorydetails.php?category=$category&city=$city

$category and $city is taken using $_GET

The script perfectly works for categories and cities with a name without space.

What I mean is, if I select Sacramento, the query works well.

If I select Los Angeles, my link looks like this:
categorydetails.php?category=Automobile&city=Los

It excludes "Angeles". I am assuming it has to do something with the space in the middle.

How do I over come this.

I link should actually look like this:
categorydetails.php?category=Automobile&city=Los Angeles.

Help me.

Regards,

[kvnband]

str_replace(" ", "%20", "$city")

That will replace the spaces with %20, which is identical to a space in a URL.

Kevin

[kvnband]

Sorry

PHP Code:

categorydetails.php?category=$category&city=str_replace(" ", "%20", "$city") 

Pretty sure that'll work in your case

[mikaelf]

You'd better use PHP built-in function: urlencode and urldecode to safely cast your url.

PHP Code:

print "<a href=\"".urlencode("categorydetails.php?category=$category&city=$city")."\">Go to details</a>";