Flex 4 get data from php script?

I'm working with wordpress,and trying to paste video url to video player I have php script that get from I database video url.

$post_id = $_GET['post_id'];

global $wpdb;

$query = "SELECT * FROM wp_posts WHERE wp_posts.post_type = 'attachment' AND wp_posts.post_mime_type LIKE '%flv%' AND wp_posts.post_parent = $post_id";

$result = $wpdb->开发者_开发百科get_row($query);

$video = $result->guid;

Can someone help me with this,to finish this thing.

HTTPService id="video_url" resultFormat="text"

VideoPlayer x="10" y="10" width="384" height="308" source="HERE I NEED TO LOAD DINAMICLY VIDEO URL" id="videoDisplay" autoPlay="false"

Video url is pulled when page loads. Script that pull data from database and player are on the same page.

Can someone help me with this please.

---

If you are getting the video's id on the same script that displays the player you can parse the data to flex application using flashvars. In this case there is no need for the HTTPservice. You will use php to get the id and then, when you will display the player you will send to it the id:

Check this link for detailed info on how to set the flashvars.

And this one to see how you work with flashvars in flex4.