make mysql array urlable

[devil_online]

Hi, I'm doing an mysql array but i want that the results are urlable.

is there a way of doing this?

thanks

[dp777]

you're best bet is probably pulling it into php and using the urlencode fuction.

[devil_online]

well I have this code:

 
$result1 = mysql_query( "SELECT * FROM team);
print "<table border=2>";
while ($row1 = mysql_fetch_array($result1)) {
print "<td width=\"114\">" . urlencode ($row1['names']);

but it prints this:
John+Wayne

how can i make it right?

thanks

[coreyp_1]

urlencode() should be used only if you are outputting a hyperlink.

If all you are doing is putting the mysql data into a table, then you would probably have better luck with htmlspecialchars() instead.

[devil_online]

can you give me some example?

thanks

[coreyp_1]

Using the code you posted earlier:

$result1 = mysql_query( "SELECT * FROM team);
print "<table border=2>";
while ($row1 = mysql_fetch_array($result1)) {
  print "<td width="114\">" . htmlspecialchars ($row1['names']);
}

htmlspecialchars() just converts letters like "<" to "&lt;", etc. If the text in your database is "<b>", then it will be translated to "&lt;b&gt;". This way, it will show up as "<b>", and not be interpreted as a bold tag.