loadVars problem!

[MJB3K]

I have a problem with the loadVars.

i am extracting the data out of a MySQL db via php.

my code:

<?php

include "../../gr/config.php";

$q = mysql_query("SELECT title, news, subDate FROM gr_news WHERE view = 'yes'") or die("news=".mysql_error());
	while(list($t,$n,$sd) = mysql_fetch_row($q)){
		echo "news=<b>$t</b><br>-$sd<br><br>$n<br><br>";
	}

?>

that loads fine, but if i include <font color=#99FF00></font> it won't display on the page?

<?php

include "../../gr/config.php";

$q = mysql_query("SELECT title, news, subDate FROM gr_news WHERE view = 'yes'") or die("news=".mysql_error());
	while(list($t,$n,$sd) = mysql_fetch_row($q)){
		echo "news=<font color=#99FF00><b>$t</b><br>-$sd</font><br><br>$n<br><br>";
	}

?>

i have set the HTML tab to true!

any ideas?

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[pixl8r]

Just a guess but try adding the single quotes:

<font color='#99FF00'>abc</font>

Hope it helps.

Wow JT that almost looked like you knew what you were doing!

 

[MJB3K]

yea that worked great ta. now another problem.

when its loaded into the textbox, the top one is ok but then the rest say news=The title etc

e.g.

Welcome back to GameRevolt
-31/05/2004

Welcome back to GameRevolt, we are finally here again after 2 years of waiting with a new, better design, we are currently building the site but we will let you know when more features become available

news=Euro 2004 << why does it say news= ??
-08/06/2004

any ideas?

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[pixl8r]

Which part of that is coming out of the php page?

Wow JT that almost looked like you knew what you were doing!

 

[MJB3K]

this is coming from the php page:

Welcome back to GameRevolt
-31/05/2004

Welcome back to GameRevolt, we are finally here again after 2 years of waiting with a new, better design, we are currently building the site but we will let you know when more features become available

news=Euro 2004 << why does it say news= ??
-08/06/2004


Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[pixl8r]

Can you post your Flash code? It looks like you might be sending 2 php variables to the same flash text field. That is not a problem if you are using instanceName.text to populate the text field but will give you fits if you are using the var property.

Wow JT that almost looked like you knew what you were doing!

 

[MJB3K]

/*******************************
loading text
*******************************/
lv2 = new LoadVars();
lv2.onLoad = function() {
	_root.home.html = true;
	_root.home.htmlText = lv2.news;
};
lv2.sendAndLoad("newstest.php", lv2, "GET");

stop();

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[MJB3K]

and another thing, the code is in a home.swf which gets loaded into the main movie!

if i load the home.swf without the loadVars(); i dont get any errors, however if i do i get:

*** Security Sandbox Violation ***
SecurityDomain '

http://localhost/hartwell/binary/home.swf?id=452'

tried to access incompatible context 'file:///C|/Inetpub/

http://wwwroot/hartwell/binary/binary.swf'

any ideas on that??


Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[pixl8r]

Try putting an & in front of news= in the php line. So it would read:

while(list($t,$n,$sd) = mysql_fetch_row($q)){
        echo "&news=<font color=#99FF00><b>$t</b><br>-...

Wow JT that almost looked like you knew what you were doing!