[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]

Nom dzieki za pomoc (IMG:style_emoticons/default/smile.gif)

Jeszcze jedno pytanie, bo chciałem, aby zeby wybieralo tylko z tabeli vote i z kolumny "polskie" gdzie "nie" jak to trzeba wpisac (IMG:style_emoticons/default/tongue.gif) ?
Bo tak na pewno nie:

[PHP] pobierz, plaintext 
 $data = mysql_query("SELECT *, total / votes AS average FROM vote ORDER BY average DESC," . "SELECT * FROM vote WHERE polskie=nie ") or die(mysql_error()); 
[PHP] pobierz, plaintext 

I jak bym chcial dodac jeszcze 1 warunek np: kolumna "gatunek" gdzie "pop"
Do bazy dopisalem za pomoca funkcji set np: wartosc: 'tak','nie'

Dobra juz mam ^^:

[PHP] pobierz, plaintext 
 $data = mysql_query("SELECT *, total / votes AS average FROM vote WHERE polskie='nie' ORDER BY average DESC") or die(mysql_error()); 
[PHP] pobierz, plaintext 

Wie ktos jak zrobic zeby przy kazdej zapetlonej pozycji pojawiaja sie kolejna liczba np 1,2,3,4?

Haloooo
Moze ktos pomoc??

Ten post edytował imatix 13.05.2010, 15:14:54