calling array in url error

[wazo]

Hi guys

I'm calling a array from my database

its a list of categories. Words like Construction are fine. But when its like
Media & Creative or Recruitment Consultancy

it stops displaying anything after the first word



it displays it ok when im printing it out, but when I call it in the url (please point your cursor over a two worder)

It only shows the first word


Thanks in advance for your help

[php_daemon]

How does the html source look like?

[wazo]

<?php



$id = $_GET['id'];
$sql = " select * from category ORDER BY category ASC";
$result = mysql_query ($sql);

$i = 0;
$row = mysql_fetch_array( $result );

echo "<table width=100%><tr><td>";
while( $i<18 ) {
    echo "<font size=2><A href=sector.php?category=$row[category]>$row[category]</a><br>";
    $row = mysql_fetch_array( $result );
    $i++;
}

echo "</td>";
echo "<td>";

while( $i >= 18 && $i<36 ) {
    echo "<font size=2><A href=sector.php?category=$row[category]>$row[category]</a><br>";
    $row = mysql_fetch_array( $result );
    $i++;
}

echo "</td></tr></table>";


?>

[php_daemon]

I asked about the html source for a reason. If you checked that, the links would look like this:

<A href=sector.php?category=Recruitment Consultancy>Recruitment Consultancy</a>

You can see what's wrong?

Quote the urls:

echo "<font size=2><A href=\"sector.php?category=$row[category]\">$row[category]</a><br>";

[byron3@earthlink]

Use urlencode() to encode your get data parameters. The blank space will need to be replaced with a +.
Documentation @ : http://us.php.net/urlencode