Colorchange with PHP loading data into Flash

1

Hi,

I have two mc’s (mc1 and mc2) on the stage and two textfields (color1 and color2). From a database through PHP I load two strings, for example ‘FF0000’ and ‘FFCCCC’. The funny thing is that with the codes I use, the textfields both show the right text. But mc1 makes the right colorchange, where mc2 turns to black.

AS:

color_read_lv = new LoadVars();
color_read_lv.onLoad = function(success) {
 if (success) {
  color1.text = color_read_lv.mc1;
  color2.text = color_read_lv.mc2;
  var headerColor = new Color(mc1);
  var h = "0x"+color_read_lv.mc1;
  headerColor.setRGB(h);
  var otherColor = new Color(mc2);
  var h = "0x"+color_read_lv.mc2;
  otherColor.setRGB(h);
 } else {
  color2.text = "error loading text";
 }
};
color_read_lv.load("color_read.php");

PHP:

 
$query1 = "SELECT color FROM nieuws WHERE id = '1'";
$result1 = @mysql_query($query1);
if (!$result1) {
exit;
}
$table1 = mysql_fetch_array($result1);
$color1=$table1['color'];
print"&mc2=$color1";
$query2 = "SELECT color FROM nieuws WHERE id = '2'";
$result2 = @mysql_query($query2);
if (!$result2) {
exit;
}
$table2 = mysql_fetch_array($result2);
$color2 =$table2['color'];
print"&mc1=$color2";
mysql_close($connection);

And although the dat seem to come in (they show in the textfields), I have a feeling that the problem has to do with my PHP script. Because only query1 seems to do the job all the way (textfield and mc change).

Thanks,

Jerryj.