A newbie with a Flash/mysql crisis

[angela ryder]

Howdy! I am hoping one of you gurus can help me... I have a MySql/PHP database set up... it's populated and all... and I have a flash site that's calling to it. Problem is- someone played with the script I had to actually call to the database... and i can't seem to find my problem...

I have this:
loadVariables("http://localhost/omrarchdb/projects.php?id=
           <http://localhost/omrarchdb/projects.php?id=>
           <http://localhost/omrarchdb/projects.php?id=
           <http://localhost/omrarchdb/projects.php?id=>>"+_level0.id, this,
           "GET");        
loadVariables("tempInput.txt", this);

Do I have a typo?

Ahhhhhhh!

~Migrane Girl

[Ronald Wernecke]

Hi Angela,
what are you trying to do with this line:

loadVariables("http://localhost/omrarchdb/projects.php?id=
          <http://localhost/omrarchdb/projects.php?id=>
          <http://localhost/omrarchdb/projects.php?id=
          <http://localhost/omrarchdb/projects.php?id=>>"+_level0.id, this,
          "GET");        

How does your php-script look?

[angela ryder]

I have about 50 projects in a MySQl database- whtn you choose a thumbnail, this script is supposed to find the id# assigned to that thumb and call that id from the database.. I have the index key is id_db.. and I have:
db_project
db_location
db_service
db_quote
db_text
db_images
with in each project.

Did that makes sense?

A programmer gave me the script that I posted and you saw, yet he must have missed something....

I thank you for helping me! My head hurts from banging it against the wall.

[Ronald Wernecke]

OK Angela,
one step after the other.
It makes sense, yes.
Image in the DB is a path to the image? Right?
I need some more details on the flash and php side.
What does php deliver and how is it handled in flash?

If you want more details of how flash talks to php, read the article in the technical reference area here in this board.

If you give some more details, we can help you getting the things running.

[Musicman]

Hi,

I guess some software was playing tricks on you, abd the code should just be
loadVariables("http://localhost/omrarchdb/projects.php?id="+_level0.id, this,, "GET")
loadVariables("tempInput.txt", this);

May I suggest to show the full code - Ithe use of a tempinput.txt suggests that there might be errors in the code...
The first call sends all your current vars (those in the timeline where you have put the code) as well as the id variable and might get some variables from the php in return
A simultaneous call asks the server to send the text file. If the purpose of the php is writing the text file, you are gambling with server timing - the text file may be delivered before the php writes it, or the other way round.

Muicman