Hi, i got this following code that fetch data from a mySQL data base for a high score board… unfortunley it isn’t working and i have absolutly no idea what went wrong… can anyone help me on this?
<?
//This first line of Code is to load your database variables.
include ('include.php');
//This connects to your database.
mysql_connect($server,$user,$pass);
@mysql_select_db("$dbase");
//This is the SQL statement that will get your settings from the Database.
$result = mysql_query("SELECT * FROM $tablename ORDER BY uScore DESC");
$rn = 0;
//This sets the variables from the Database
//flash variable //dbase coloum name
//---------01
$uName1 = mysql_result($result,$rn,"uName");
$uScore1 = mysql_result($result,$rn,"uScore");
//---------02
$uName2 = mysql_result($result,$rn+1,"uName");
$uScore2 = mysql_result($result,$rn+1,"uScore");
//---------03
$uName3 = mysql_result($result,$rn+2,"uName");
$uScore3 = mysql_result($result,$rn+2,"uScore");
//---------04
$uName4 = mysql_result($result,$rn+3,"uName");
$uScore4 = mysql_result($result,$rn+3,"uScore");
//---------05
$uName5 = mysql_result($result,$rn+4,"uName");
$uScore5 = mysql_result($result,$rn+4,"uScore");
//---------06
$uName6 = mysql_result($result,$rn+5,"uName");
$uScore6 = mysql_result($result,$rn+5,"uScore");
//---------07
$uName7 = mysql_result($result,$rn+6,"uName");
$uScore7 = mysql_result($result,$rn+6,"uScore");
//---------08
$uName8 = mysql_result($result,$rn+7,"uName");
$uScore8 = mysql_result($result,$rn+7,"uScore");
//---------09
$uName9 = mysql_result($result,$rn+8,"uName");
$uScore9 = mysql_result($result,$rn+8,"uScore");
//---------10
$uName10 = mysql_result($result,$rn+9,"uName");
$uScore10 = mysql_result($result,$rn+9,"uScore");
//------------------
//check for server error
if(!@mysql_connect($server, $user, $pass)) {
print "status=There is a problem with the server, please try again";
}
if(!@mysql_select_db($dbase)) {
print "status=There is a problem with the server, please try again";
}
if(!$result) {
print "status=There is a problem with the server, please try again";
}
//turn it into flash variable format
// ---set 1
$uName1 ="&uName1=$uName1";
echo "$uName1";
$uScore1 ="&uScore1=$uScore1";
echo "$uScore1";
// ---set 2
$uName2 ="&uName2=$uName2";
echo "$uName2";
$uScore2 ="&uScore2=$uScore2";
echo "$uScore2";
// ---set 3
$uName3 ="&uName3=$uName3";
echo "$uName3";
$uScore3 ="&uScore3=$uScore3";
echo "$uScore3";
// ---set 4
$uName4 ="&uName4=$uName4";
echo "$uName4";
$uScore4 ="&uScore4=$uScore4";
echo "$uScore4";
// ---set 5
$uName5 ="&uName5=$uName5";
echo "$uName5";
$uScore5 ="&uScore5=$uScore5";
echo "$uScore5";
// ---set 6
$uName6 ="&uName6=$uName6";
echo "$uName6";
$uScore6 ="&uScore6=$uScore6";
echo "$uScore6";
// ---set 7
$uName7 ="&uName7=$uName7";
echo "$uName7";
$uScore7 ="&uScore7=$uScore7";
echo "$uScore7";
// ---set 8
$uName8 ="&uName8=$uName8";
echo "$uName8";
$uScore8 ="&uScore8=$uScore8";
echo "$uScore8";
// ---set 9
$uName9 ="&uName9=$uName9";
echo "$uName9";
$uScore9 ="&uScore9=$uScore9";
echo "$uScore9";
// ---set 10
$uName10 ="&uName10=$uName10";
echo "$uName10";
$uScore10 ="&uScore10=$uScore10";
echo "$uScore10";
//echo "&dataLoaded=1";
echo "&dragonflyLoad=1";
}else {
echo "&dragonflyLoad=2";
}
?>