This code returns a single value when searching only by the particular game:
Code: Select all
$sql4="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid' ORDER BY `score` DESC LIMIT 1";
$result4=mysql_query($sql4);
$row4 = mysql_fetch_array($result4);
$scorenum = mysql_num_rows($result4);
echo "$scorenum";
if($scorenum == 1){
$yourscore = $row4["score"];
}
else {
$yourscore = "None";
}Code: Select all
$sql4="SELECT * FROM `arcade_highscores` WHERE `user` = '$user' ORDER BY `score` DESC LIMIT 1";
$result4=mysql_query($sql4);
$row4 = mysql_fetch_array($result4);
$scorenum = mysql_num_rows($result4);
echo "$scorenum";
if($scorenum == 1){
$yourscore = $row4["score"];
}
else {
$yourscore = "None";
}Code: Select all
$sql4="SELECT * FROM `arcade_highscores` WHERE `gamename` = '$gameid', `user` = '$user' ORDER BY `score` DESC LIMIT 1";
$result4=mysql_query($sql4);
$row4 = mysql_fetch_array($result4);
$scorenum = mysql_num_rows($result4);
echo "$scorenum";
if($scorenum == 1){
$yourscore = $row4["score"];
}
else {
$yourscore = "None";
}