Integrating Flash and mySQL

#include "PHPObject.as"

tmp = new PHPObject();
tmp.setDefaultGatewayKey("secret"); // CHANGE THIS TO
//WHATEVER SECRET KEY YOU SET IN Gateway.php
tmp.setDefaultGatewayUrl("http://www.yourdomain.com/pathto/Gateway.php"); // CHANGE THIS
//TO WHERE YOU PLACE Gateway.php
delete tmp;

myFoo = new PHPObject("cards"); // declare a new object and link it to a remote PHP class


// set up responder
myFoo.getcard_onResult = function(result) {
        
        id.text = result[0];
        sid.text = result[1];
        s_name.text = result[2];
        s_email.text = result[3];
        r_name.text = result[4];
        r_email.text = result[5];
        message.text = result[6];
        card.text = result[7];
        uniqueid.text = result[8];
        beenread.text = result[9];
}

// invoke method
myFoo.getcard("rJ7WP605");

<?

class cards {
        function getcard($getcard) {
                
                $db_name = "yourdbname";
                $connection = @mysql_connect("localhost", "username", "password") or die("Cound not connect to database");
                mysql_select_db($db_name, $connection) or die("Count not select database");
                $query = "SELECT * FROM ecards WHERE sid LIKE '$getcard'";
                $q_result = mysql_query($query);
                return mysql_fetch_row($q_result);
                
        }
}

?>