[MySQL][PHP]Problem ze skryptem - głosowanie z MySQL Opcje

[imatix]

Może ktos wie czemu ten skrypt nie działa?? :

[PHP] pobierz, plaintext 
<?php 
 // Connects to your Database 
 mysql_connect("mysql1.yoyo.pl", "dbxxxxxx", "haslo") or die(mysql_error()); 
 mysql_select_db("dbxxxxxx") or die(mysql_error()); 
 
 //We only run this code if the user has just clicked a voting link
 if ( $mode=="vote") 
 { 
 
 //If the user has already voted on the particular thing, we do not allow them to vote again 	$cookie = "Mysite$id"; 
 	if(isset($_COOKIE[$cookie])) 
 		{ 
 		Echo "Sorry You have already ranked that site <p>"; 
 		} 
 
 //Otherwise, we set a cooking telling us they have now voted 
 	else 
 		{ 
 		$month = 2592000 + time(); 
 		setcookie(Mysite.$id, Voted, $month); 
 
 		 //Then we update the voting information by adding 1 to the total votes and adding their vote (1,2,3,etc) to the total rating 
 mysql_query ("UPDATE vote SET total = total+$voted, votes = votes+1 WHERE id = $id"); 
 		Echo "Your vote has been cast <p>"; 
 		} 
 } 
 
 //Puts SQL Data into an array
 $data = mysql_query("SELECT * FROM vote") or die(mysql_error()); 
 
 //Now we loop through all the data 
 while($ratings = mysql_fetch_array( $data )) 
 { 
 
 //This outputs the sites name 
 Echo "Name: " .$ratings['name']."<br>"; 
 
 //This calculates the sites ranking and then outputs it - rounded to 1 decimal 
 $current = $ratings[total] / $ratings[votes]; 
 Echo "Current Rating: " . round($current, 1) . "<br>"; 
 
 //This creates 5 links to vote a 1, 2, 3, 4, or 5 rating for each particular item 
 Echo "Rank Me: "; 
 Echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=1&id=".$ratings[id].">Vote 1</a> | "; 
 Echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=2&id=".$ratings[id].">Vote 2</a> | "; 
 Echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=3&id=".$ratings[id].">Vote 3</a> | "; 
 Echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=4&id=".$ratings[id].">Vote 4</a> | "; 
 Echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=5&id=".$ratings[id].">Vote 5</a><p>"; 
 } 
 
 
 ?>
[PHP] pobierz, plaintext 

Wczesniej dodalem do bazy danych :

[SQL] pobierz, plaintext 
CREATE TABLE vote (id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30), total INTEGER, votes INTEGER) 
[SQL] pobierz, plaintext 

oraz

[SQL] pobierz, plaintext 
INSERT INTO vote (name, total, votes) VALUES ( "First item", 45, 10 ), ( "Second item", 15, 4 ), ( "Third thing", 25, 7 ), ( "The Forth", 20, 5 ), ( "Fifth Thing", 0, 0 )
[SQL] pobierz, plaintext 

Na stronie wszystko sie wyswietla, ale skrypt nie liczy sredniej, po kliknieciu nic sie nie zmienia:
Adres do skryptu http://www.muzycznalista.yoyo.pl/

Prosze o pomoc.
Pozdro

Ten post edytował imatix 13.05.2010, 09:44:06

[imatix]

[PHP] pobierz, plaintext 
//Wstawienie informacji z MySQL
$data = mysql_query("SELECT *, total / votes AS average FROM vote ORDER BY average DESC") or die(mysql_error());
 
for($i = 1; $row = mysql_fetch_assoc($data); ++$i) {
   // i tutaj masz liczbę w zmiennej $i, co wiersz większą o 1
}
 //Zapętlenie skryptu 
 while($ratings = mysql_fetch_array( $data )) 
 { 
 
 //Wykonawca 
 Echo "<div id=lista><TABLE border=0 cellspacing=0 cellpadding=0><TR><TD><IMG SRC=img/nuta.jpg ALT=nuta></TD>
 <TD width=300px;>" .$ratings['wykonawca']." - "; 
 
 //Tytuł piosenki
 Echo "" .$ratings['tytul']."</TD>"; 
 
 //Link do YouTube  
 Echo "<TD width=50px;><a href=" .$ratings['adres']." target=_blank>Play</a></TD>";
 
 //Wstawienie średniej arytmetycznej 
 $current = $ratings['average']; 
 Echo "<TD width=75px;>Ocena: " . round($current, 1) . "</TD>"; 
[PHP] pobierz, plaintext 

Cos mi sie strona nie chce wlaczac dalej