ottengo questo errore:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
il database è configurato bene, e questo stesso script funziona benissimo su di un'altra tabella dove al posto di alb c'è song...
cosa sbaglio??
Codice PHP:<html>
<head>
<title>Voto</title>
</head>
<body>
<?
// --------------------------------------------- PART 1 -------------------------------------
//PLEASE CHANGE THESE VALUES !!
$dbhost = "xxx"; // DB HOST
$dbusername = "xxx"; // USERNAME
$dbpass = "xxx"; // USER PASSWORD
$dbname = "xxx"; // DB NAME
//PLEASE CHANGE THESE VALUES !!
$connection = mysql_connect($dbhost, $dbusername, $dbpass);
$SelectedDB = mysql_select_db($dbname);
$query = mysql_query ("SELECT alb_rating, alb_num_votes FROM alb WHERE uid=$alb_id") or die (mysql_error());
while(list($alb_rating, $alb_num_votes)= mysql_fetch_array($query))
{
$new_count = ($alb_num_votes + 1);
$song_rating2 = ($alb_rating * $alb_num_votes);
$new_rating = (($rating + $alb_rating2) / ($new_count));
$new_rating2 = number_format($new_rating, 2, '.', '');
$update_rating = mysql_query("UPDATE alb SET
alb_rating='$new_rating2',alb_num_votes='$new_count' WHERE uid=$alb_id");
echo "<div align=\"center\"><font face=\"verdana\" size=\"1\">[b]
Grazie per il voto!</p>
L\'album ha ora una valutazione di:
$new_rating2 su 5</p>
<p align=\"center\"><a href=\"javascript:history.back();\"><< Torna</a>";
}
?>
</body>
</html>
Rispondi quotando