gyanmic Link building

[Shalini Bhalla]

i have data in my database from which i display areas on website page . And i want if anybody clicks in any area , records pertaining to that area should display .

I have success fully done this but the problem is that if aome one clicks on "Dwarka" records are being diaplayed but if someone clicks on "civil line" then request variaable passes to next page is just "civil" and not "civil lines"

and my records are not displayed ............... ........

can anybody help me
Followin is my link building coding :

[PHP] <? $sql1 = "select distinct(addres s2) as 'area' from agents order by address2";
$result1 = mysql_query($sq l1);
while($row=mysq l_fetch_array($ result1))
{ ?>
<tr>
<td><? $add = $row['area'];
echo "<a href=http://www.newdelhigui de.net/travel-agents-display.php?add ress2='".$add." '>".$row['area']."</a>";


?> [/PHP]

[Markus]

i have data in my database from which i display areas on website page . And i want if anybody clicks in any area , records pertaining to that area should display .

I have success fully done this but the problem is that if aome one clicks on "Dwarka" records are being diaplayed but if someone clicks on "civil line" then request variaable passes to next page is just "civil" and not "civil lines"

and my records are not displayed ............... ........

can anybody help me
Followin is my link building coding :

[PHP] <? $sql1 = "select distinct(addres s2) as 'area' from agents order by address2";
$result1 = mysql_query($sq l1);
while($row=mysq l_fetch_array($ result1))
{ ?>
<tr>
<td><? $add = $row['area'];
echo "<a href=http://www.newdelhigui de.net/travel-agents-display.php?add ress2='".$add." '>".$row['area']."</a>";


?> [/PHP]

Try urlencode()'ing your $add var, then urldecode()'ing on your display.php
[php]
$add = urlencode($row['area']);
[/php]