# PHP dosen't recoganise the var!

**URL:** https://forum.kirupa.com/t/php-dosent-recoganise-the-var/299409
**Category:** Uncategorized
**Created:** [November 4, 2009, 5:48pm UTC](https://forum.kirupa.com/t/php-dosent-recoganise-the-var/299409 "2009-11-04T17:48:58Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ron\_ron](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@ron\_ron](https://forum.kirupa.com/u/ron_ron)
#### Post date: [November 4, 2009, 5:48pm UTC](https://forum.kirupa.com/t/php-dosent-recoganise-the-var/299409/1 "2009-11-04T17:48:58Z")

</div>

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]](http://www.abc.com/myphp.php?%22+%5BCOLOR=red%5Dfin%5B/COLOR%5D), 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();

?\>