Flash - Get PHP data problem.. +rep

Hello everyone.

I have an annoying problem with Flash.
I want to get the data from a PHP page (which collects data from a MySQL database). That part works alright for what is needed.

Show Hide

http://freyta.net/mysql/hot.php?name=shane

is the link to the data.

Now I load my data data using

PHP Code:

---

onClipEvent (load) {
    i = new LoadVars();
    i.load("http://freyta.net/mysql/hot.php?name=shane", this, "GET");
} 


---

which recieves the data "127="...

How do I get rid of that equals sign :S


Sorry for the really dumb question

It works?

No, it has the stupid equals sign...
I can't just load the data "127"... (it works fine on the webpage but when i load it into flash it adds the = sign)

show the flash page.. please and your php source.

http://freyta.net/mysql/hot.phps
http://freyta.net/mysql/gayz.fla

(its the little square box with all the code for the fla ;))

edit:

Maybe it is just my PC but it wants to download the phps

Here is the code in the spoiler

Show Hide

PHP Code:

---

<?php
include 'sqlConnection.php'; 
$test = $_GET[name];

$getuser = mysql_query("SELECT * FROM name WHERE name = '$test'");


while ($user = mysql_fetch_array($getuser)){


//echo ("name=$user[name]");
echo ("$user[hot]");
}
?>

---

To be sure you could shortern the string to three in flash (duno how) or in php:

Code:

---


$user = $user[hot];
$user = substr($user,0,-1);

---

Edited by ,Jess, (Forum Super Moderator): Double posts merged due to lag.

If I remember correctly, flash can read data like this:

Quote:

---

&name=that
&this=poop

---

This is loading data using LoadVars

ActionScript:

PHP Code:

---

data = new LoadVars();
data.load( "http://www.disasterpiece.co.uk/flashData.php" );
data.onLoad = function( success )
{
    if( success )
    {
        trace( data.myMessage );
    }
} 


---

Returns
"Joygasmic blowjob"

The PHP page if you're interested whats on it (doesn't have to be a php page, can be a html/text/etc page)

Live content:
"&myMessage=Joygasmic blowjob"

PHP code:

PHP Code:

---

<?php
// Using PHP just to explain
$variable = 'Joygasmic blowjob';
echo '&myMessage=' . $variable;
?>

---

Hope this helped.

Okay that worked :)! (it got the variable properlly)

But, now my rotation won't work :S?

PHP Code:

---

onClipEvent (load) {
    data = new LoadVars();
    data.load("http://www.freyta.net/flashData.php");
    data.onLoad = function(success) {
        i = data.myMessage;
        if (success) {
            trace(i);
            if (_root.mcobj._rotation<tobe) {
                _root.mcobj._rotation++;
            }
        }
    };
} 


---

Why doesn't that work?

This is really stupid :eusa_wall

I dont understand what you are trying to do, explain more and I can help you.

Okay...

Here is my idea.
I want to make an application called the 'hot-o-dometer'. Its like a speedometer but instead of saying mph or kmph, it tells you how 'hot' you are..

How it works:
I get a variable (which we called myMessage) from a remote location, and then dial turns that many degrees to point to how 'hot' you are..


Does that make sense?