HELP: Passing value from DB in URL, spaces problem

[martincrumlish]

Hi,

I have a problem. I have written a web app that takes results from an Informix DB. this DB is part of a legacy system and as such, I cant change the data in it. i am only writing something that outputs the data.

One of the DB fields holds placenems and these in some cases are two words ie: San Diego. Now, there is a second page which produces further results depending on the placename. I pass the placename value to the next page in the URL but, and here's the problem:

Normally, I pass the value like so: link.php?name=$placename If the placename is Dublin then the link would be

link.php?name=Dublin

However, if the placename is San Diego this becomes

link.php?name=San Diego

When I try to pass this in the URL it doesnt work and only passes it like this:

link.php?name=San

As such, this messes up the query that relies on the $name value on the link.php page.

Anyone got any ideas?

Thanks,
Martin

[feldon23]

{ in your sending script }

echo "<a href=\"link.php?name=".htmlentities(urlencode($city))."\">";

{ in link.php }

if (!empty($_GET['name']))
echo "You live in".htmlspecialchars(urldecode($name)).".";