Populate Combo Box AS3 & PHP & MySQL

[JKofSpades]

 

Hey Thanks A LOT guys for all of your help.  I figured it out while playing around with it.

I didnt have to change the "VARIABLES" to "TEXT" or anything.  In variables I had to encode everything inside the strings being sent (ESPECIALLY SINCE SOME DATA INCLUDED AMPERSANDS) and leave the ampersands between the sets of data alone:

<?php
require("mychiparty_dbinfo-LOCAL.php");

$link = mysql_connect("localhost",$username,$password);
mysql_select_db($database);
$table = "venues";

$result = mysql_query("SELECT name, address FROM $table");
$cant = 0;
while($row=mysql_fetch_array($result)){
   echo "Name$cant=" . urlencode("$row[name]") . "&";
   $cant++;
}
echo "cant=$cant";
?>


Once again THANX A BUNCH!