# Need help to retrieve the data from mysql and php

**URL:** <https://forum.kirupa.com/t/need-help-to-retrieve-the-data-from-mysql-and-php/327080>\
**Category:** Uncategorized\
**Created:** [February 4, 2012, 1:22pm UTC](https://forum.kirupa.com/t/need-help-to-retrieve-the-data-from-mysql-and-php/327080 "2012-02-04T13:22:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![aruna\_juice](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aruna\_juice](https://forum.kirupa.com/u/aruna_juice)\
**Post date:** [February 4, 2012, 1:22pm UTC](https://forum.kirupa.com/t/need-help-to-retrieve-the-data-from-mysql-and-php/327080/1 "2012-02-04T13:22:50Z")

</div>

[COLOR=#333333][FONT=Segoe UI]Hello all, I am new to flash and seem to be stuck with this problem. Any guidance would be extremely appreciated.  
i am created the spinner. i am trying to give the specific value. i store the value in mysql. i am trying to send the value as a variable. but i didn’t get the value. here is my code.  
[/FONT][/COLOR]

```auto
import fl.transitions.Tween;
import fl.transitions.TweenEvent;
import fl.transitions.easing.*;

txtCount.background=true;

var request:URLRequest = new URLRequest("http://localhost/sekar/temp1.php");
        request.method = URLRequestMethod.GET;

        var loader:URLLoader = new URLLoader();
        loader.dataFormat = URLLoaderDataFormat.VARIABLES;
        loader.addEventListener(Event.COMPLETE, completeHandler);
        loader.load(request);

        function completeHandler(evt:Event) {

            var nome = evt.target.data.nome;
            

            nome_txt.text = nome;
        }

var tw:Tween = new Tween(mcArrow,"rotation",Strong.easeOut, 10, 360, 40, true); 
var numturns:int = Math.ceil(20*Math.random());
    
    txtCount.text = "Spinning...";
    txtCount.backgroundColor = 0xFF9999;
    tw.finish = numturns*1080 + nome*3.6;
tw.start();

tw.addEventListener(TweenEvent.MOTION_FINISH, spinStopped);

function spinStopped(twevt:TweenEvent):void {
    txtCount.backgroundColor = 0xFFFFFF;
    txtCount.text = String(nome);
    
}

```

this is my php code

```php

 <?php include("conn1.php");
$qP = "SELECT winid FROM winning WHERE id=1";
$rsP = mysql_query($qP);
$row = mysql_fetch_array($rsP);
extract($row);
$pot0= trim($winid);
$nome=$pot0;
echo 'nome='.$nome;
?>

```

here is my movie: [http://www.mediafire.com/?s621g7ctcx1m43s](http://www.mediafire.com/?s621g7ctcx1m43s)

[COLOR=#333333][FONT=Segoe UI]advance thanks for the help…[/FONT][/COLOR]