php 更新数据sql语句怎么写,php – SQL语句只更新一个用户的数据

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发布问题之前,你无法弄明白:)