function get_user_id($username) {
return mysql_result(mysql_query("Select id From users Where username = '" . mysql_real_escape_string($username) . "'"), 0);
}
$sql = "select * from rating
WHERE user_id=" . get_user_id($myusername) . "
ORDER BY punkte ASC";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
$catid = $row['rating_id'];
$catname = $row['song_id'];
echo "
$catname";}
?>
更新:
对不起,我发现了错误,这是非常愚蠢的:
$catid = $row['rating_id'];
$catname = $row['song_id'];
它应该是:
$catid = $row['song_id'];
$catname = $row['song_name'];
所以,谢谢大家!一如既往:在向Stackoverflow发布问题之前,你无法弄明白:)