show the votes on my website?

[masomehs]

Hi!

i just created a poll(voting script).
and i want the script to show how many that have voted:
example:

Votes
Nice page: 20 votes
Ugly page: 15 votes

The poll is connected to the database and work perfectly , when you vote it saves in the database. but i dont know how to do so it shows in the website how many votes there is. and i want them to only vote once! not many times. i guess i must use Cookies for that. i could need some help with that to.

Well, here is the code:

<? 
if(isset($_POST['vote'])) { 
echo "Du röstade på alternativ nummer ".$_POST['vote']; 
} 
$sql = "UPDATE vote SET roster=roster+1 WHERE alternativ=$_POST[vote]"; 
include_once 'connect.php'; 
mysql_query($sql); 
?>

If you need the html code to, just tell me =).

Thanks, Masomehs.

[Dolemite50]

Hi,
I cant tell, but it looks like you are already keeping track of the number of votes with this code:

$"UPDATE vote SET roster=roster+1 

If that is the case, all you have to do is select it and echo it.

$sql = "SELECT roster FROM vote";
$get_rost= mysql_query($sql) or die(mysql_error());	
$votecount = mysql_result($get_rost, 0);

and then anywhere you wanted to put it on the page you would use something like:

 echo "The total number of votes is $votecount.";

I hope that helps.

[masomehs]

thank you!
if will try that when i get home.