input text field sends to php to search database (MySQL) finds information
sends back to flash
flash takes infromation and displays it properly into dynamic text fields.
All takes place on one frame currently.

How do i find out if the variables are even being loaded into flash? I tried
trace and i get nothing returned..

Desperate help
rigpig

IE
Input (instance Name): tbxStock
Dynamic Text Fields(instance Names): tbxVIN, tbxYear

Actionscript:
function onSend()
{
formdata = new LoadVars();
formdata.first = "";
formdata.first = tbxstock.text;
replydata = new LoadVars();
replydata.reply_first = "";
replydata.onLoad = function(success)
{
if (success == true) {
tbxVIN_txt.text = replydata.VIN;
tbxVIN = tbxVIN_txt.text;
tbxYear.text = this.Year;
trace("Reply Vin " + tbxVIN);
trace ("Reply Year " + tbxYear.text);
} else {
trace("Reply Failure");
}
};
formdata.sendAndLoad("http://localhost/php/handlesubmit.php", replydata,
"POST");
}

php code
$Host="localhost";
$DBName="MyDatabase";
$TableName="inventory";
$reply_first = $HTTP_POST_VARS['first'];
$Connect=mysql_connect($Host);
mysql_select_db($DBName, $Connect);
$query = "SELECT * FROM inventory WHERE Stock_Number ='$reply_first'";
$result = mysql_query($query);
$numR = mysql_num_rows($result);
if ($numR>0) {
for($i=0; $i < $numR; $i++) {
$row = mysql_fetch_array($result);
}
$reply_first .="&Stock
Number".$i."=".$row['Stock_Number']."&VIN".$i."=".$row['VIN']."&Year"";
$values = $reply_first;
echo $values;

}else {
print "not connected ";
}
?>

php output
&Stock Number0=123&VIN0=1234567890&Stock Number0=123&VIN0=1234567890&Stock
Number1=11111&VIN1=11111111111111111