I am trying to access a mySQL database from Flash via PHP and XML.

I use this code to open the XML:
sXML.load("www.mysite.com/myscript.php?someTypeOfQuery");

When I run the compiled SWF file, the onLoad event is triggered, and the data
get successfully extracted from the XML.
However, when I run the SWF file when it's located on a web server, the onLoad
event is triggered, but no XML data exists, and the success variable returned
from the event is 'false'.

What could be wrong?

Sounds like any combination of a path, security sandbox or server side
script failure.


What happens when you place
http://www.mysite.com/myscript.php?someTypeOfQuery in the web browser
address line?

[quoted text, click to view]
Does this mean run from the IDE, the local machine?

--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
I am trying to access a mySQL database from Flash via PHP and XML.

I use this code to open the XML:
sXML.load("www.mysite.com/myscript.php?someTypeOfQuery");

When I run the compiled SWF file, the onLoad event is triggered, and the
data
get successfully extracted from the XML.
However, when I run the SWF file when it's located on a web server, the
onLoad
event is triggered, but no XML data exists, and the success variable
returned
from the event is 'false'.

What could be wrong?

Start with basic steps to exclude possibilities.
If the swf file is in a web server, load the php file with "localhost" or with
its relative path.

If the php is on another computer, outside your domain, you may need a
crossdomain.xml to resolve the problem.

Dimitar