2 words variable problem 1

[Cristii00]

I have a table in the database and one of the fields needs to have two or more words. Let's say it's a field called "name" and i have in it names like "John William Johnson", "Alley Cat" and others.
I take out all the fields in the table in a php file, and these names become links to another page "test2.php".
What i need is to take the whole variable, both two words.
Instead of having "test2.php?num=Alley" i need to have something like "test2.php?num=Alley Cat" (or eventually test2.php?num=Alley%20Cat).
In the page i open i want to have the variable as two separate words, as it was originally. For example if i need to print it, it should be "Alley Cat" , and not "Alley%20Cat"

Ok, i guess you understand my problem. So far i can only take the first word as a variable.

 

[LTeeple]

you problem is not quite clear... can you post some code?
Cheers!
Laura

 

[danielhozac]

Try this

echo '<a href=&quot;anotherpage.php?avar=' . urlencode($avar) . '&quot;>Click this link</a>';

//Daniel

 

[Cristii00]

here is my code:
..........
$sql= "SELECT * FROM names";
$sql_result = mysql_query($sql,$connection) or die ("Could not select data"

while($myrow = mysql_fetch_array($sql_result)) {
print( &quot; <tr>
<td>&quot;.$myrow[&quot;id&quot;].&quot;</td>
<td>&quot;.&quot;<A HREF=log.php?num=$myrow[name]>$myrow[name]</A>&quot;.&quot;</td>
</tr><br>&quot;
}

 

[danielhozac]

$sql= "SELECT * FROM names";
$sql_result = mysql_query($sql,$connection) or die ("Could not select data");

 while($myrow = mysql_fetch_array($sql_result)) {
        print( &quot;  <tr>
    <td>&quot;.$myrow[&quot;id&quot;].&quot;</td>
    <td>&quot;.&quot;<A HREF=\&quot;log.php?num=&quot; . urlencode($myrow[name]) . &quot;\&quot;>$myrow[name]</A>&quot;.&quot;</td>
    </tr><br>&quot;);
}

//Daniel

 

[Cristii00]

tanks daniel