Php dosen’t pick thje [COLOR=red]FIN[/COLOR] values to get the data from the mysql db. Why is that? I really don’t understand!!!
CODE:
var mcl:MovieClipLoader = new MovieClipLoader();
import gs.dataTransfer.XMLParser;;
ab1.onRelease = function() {
var [COLOR=red]fin[/COLOR] = “motors01”;
XMLParser.load("www.abc.com/myphp.php?"+[COLOR=red]fin[/COLOR], onFinish);
}
function onFinish($success:Boolean, $results:Object, $xml:XML):Void {
if ($success) {
category.text += $results.category[0].value;
namez.text += $results.namez[0].value;
CN1.text += $results.col1[0].value;
CN2.text += $results.col2[0].value;
var mclListener:Object = new Object();
mclListener.onLoadStart = function(target_mc:MovieClip) {
trace(“onLoadStart”);
};
mclListener.onLoadComplete = function(target_mc:MovieClip) {
trace(“onLoadComplete”);
};
mclListener.onLoadInit = function(target_mc:MovieClip) {
trace(“onLoadInit”);
};
var image_mcl:MovieClipLoader = new MovieClipLoader();
image_mcl.addListener(mclListener);
image_mcl.loadClip($results.image[0].value, image);
gotoAndStop(5);
}
PHP
<php
#all of this is running off the root direcory in folder test
mysql_connect(“blah blah”);
mysql_select_db(“blackchr_dyo123”);
$query = ‘SELECT * FROM dyostart’;
$results = mysql_query($query);
$SomeVar = $_GET[’[COLOR=red]fin’[/COLOR]];
$query = “SELECT * FROM dyostart WHERE idcode = ‘$SomeVar’”;
$imagepath = “”;
$results = mysql_query($query);
if($line = mysql_fetch_assoc($results)){
header(“Content-type: text/xml”);
echo ‘<?xml version=“1.0” encoding=“utf-8”?>’;
echo “<item>”;
echo “<category>”.$line[“category”]."</category>";
echo “<image>”.$imagepath.$line[“logo”]."</image>";
echo “<namez>”.$line[“namez”]."</namez>";
echo “<col1>”.$line[“col1”]."</col1>";
echo “<col2>”.$line[“col2”]."</col2>";
echo “</item>”;
}
mysql_close();
?>