PHPquery won't return correctly to Flash

Anon

I succeded to query a mySQL database from via a PHP script. At least when returning the variables not to flash, but to a new window. The variables are returned in a long string, like
&picsrc01=/15bilder/bild1.jpg&picsrc02=/15bilder/bild2.jpg&picsrc03=/15bilder/bild3.jpg...
Flash won't accept these variables.
If I send a manually created string back to flash, not using the returns of the database, Flash will accept the variables.
I have verified that the strings (auto and manual) are COMPLETELY THE SAME. (used PHP for comparing with
IF ($strgreturn = $strgreturn2) echo "The same!";

The database contains path-informations for pictures to be loaded dynamically by Flash. A query pictgt='pc010101' will return picsrc=/15bilder/bild1.jpg
For building the long return string I query the DB and add the results to the former emptied string:
$strgreturn2.="&picsrc".$j."=".$tmpstring['0'];
where $j is my incrementing pic-# and $tmpstring the return by the DB query.

Why does the automatically created string not work?

Anon

I succeded to query a mySQL database from Flash via a PHP script...

Anon

I've found myself in this situation on one or two occasions as well. The solutions were usually to be found in the actionscript rather than the php code. Here are some of the mistakes I tend to make.

1)Have you initialised all the variables before assigning them a value? Sometimes Flash doesn't seem to worry about this, other times it does.

eg:
var myUrl="";
myURL=_root.picsrc01;

will work - without the first line, it may not.

2)How about the preloader? Has the movie had time to load all the data in? If not, add "&done=1" as the final variable in your php output; then, you need a loop such as

//frame 1
loadVariablesNum ("mydata.txt",0);
//frame 3
if(_level0.done==1){
nextFrame();
play();}else{
prevFrame();
play();}

to ensure the whole lot is loaded in.

Truth be told, I tend not to use the long string method now with anything more than 10-15 variables 'cos finding the problems is an absolute sod. How about generating an array, or better still an XML object? sounds like a lot of hassle, but it sure helps with reading output and sorting things out.

If you've got all the above already covered, sorry - how about posting the actionscript on your loading sequence so we can figuer it out. In return, I'll show you the XML code I'm using

All the best, Al

yurko

I suspect that this is wrong:
IF ($strgreturn = $strgreturn2) echo "The same!";
Shoud be:
IF ($strgreturn == $strgreturn2) echo "The same!" else echo("<hr>GRRR<hr>");

also try this:
echo(">$strgreturn<<br>");
echo(">$strgreturn2<<br>");
to check exactly all characters in the strings.

If you say that Flash accets string made manually and doesn't accept one generated then the only reason is that strings are not the same.

hope this helps.