I’m trying to link a MySQL database via php to my flash movie, whcih should display a list of pubs. I have a movie clip (which just consists of a dynamic text box with variable name ‘house’) which has these actions attached to it:
onClipEvent (load) {
type=“Pub”;
loadVariables(“http://localhost/read.php”, this, “POST”);
}
My PHP file is called ‘read.php’ and has the following code (i’ve replaced the username/password with ???):
<?php
$type = $_POST[“type”];
$dbhost = “localhost”;
$dbname = “eldridge”;
$dbuname = “???”;
$dbpass = “???”;
mysql_connect($dbhost, $dbuname, $dbpass);
@mysql_select_db($dbname);
$connect = @mysql_connect($dbhost, $dbuname, $dbpass);
if (!$connect){
echo “&house=Server Error&”;
exit;
}
if (!@mysql_select_db($dbname)){
echo"&house=Database Error&";
exit;
}
$result = @mysql_query(“SELECT house FROM houses WHERE type=’$type’”);
if ($result && @mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)){
$homes = $row[‘house’];
$return .= ‘’ . $homes . ‘<br>’;
}
print"&house=$return&";
}else{
print"&house=No Results&";
}
mysql_close($connect);
?>
This doesn’t seem to work at all and i’m getting no results at all, could anyone suggest what i’ve done wrong or what i could do to try and fix it?
Thanks in advance for any help