Afstemning, hvor ip logges

Hej eksperter.

Jeg har pt. en afstemning på min side hvor jeg ligger en cookie ind. Det virker også meget fint sålænge folk har slået cookie til i browseren.

Jeg vil gerne have lavet en ny afstemning hvor ip'en logges. Hvordan gør jeg det?

Herunder ses koderne for min afstemning.

index.php:
<html>

<head>
<title>Afstemning</title>
<script language="JavaScript1.2" src="/script/fodnote.js"></script>
<link rel=stylesheet href="/script/link.css" type="text/css">
</head>

<body leftmargin="5" rigthmargin="5" topmargin="5" marginwidth="0" marginheight="0">

<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<p align="center"><b><font face="Verdana" size="4">Afstemning:</font></b></p>

<?php

print "<div align='center'>";
print "<center>";
print "<table border='0' width='300' cellspacing='0' cellpadding='4'>";
print "  <tr>";
print "    <td width='100%' bgcolor='#808080'>";
print "      <p align='center'><font face='Verdana' size='1' color='#FFFFFF'>";

$connection = mysql_connect("**--**","**--**","**--**");
$db = "**--**";
mysql_select_db($db);

$result = mysql_query("SELECT nr, overskrift FROM afstemning ORDER BY nr DESC");

$row = mysql_fetch_array($result);
$overskrift = $row["overskrift"];
$nr = $row["nr"];

print $overskrift;

print "</b></font></td>";
print "</tr>";
print "</table>";

print "<br>";

print "<table border='0' width='300' cellspacing='0' cellpadding='0'>";
print "  <tr>";

if (!isset($_COOKIE["harStemt"]) || $_COOKIE["harStemt"]!=$nr)
{

print "    <td width='100%' valign='top'><form action='stem.php' method='post'>";
print "      <font size='1' face='Verdana' color='#000000'>";

$result = mysql_query("SELECT indeks, svar FROM svar WHERE afstemningsnr=$nr ORDER BY indeks");

while($row = mysql_fetch_array($result))
{ $indeks = $row["indeks"];
$svar = $row["svar"];

print "<input type='radio' value='$indeks' name='afstemning'>$svar<br>";
}

print "<img border='0' src='/grafik/afstand.gif' width='1' height='5'><br>";
print "<center><br><input type='submit' class='input_knap' value='Stem' name='submit' style='font-family: Verdana'></center></font></form></td>";
}
else
{
print "<td width='300' valign='top'>";
print "<font size='1' face='Verdana' color='#000000'>";

$result = mysql_query("SELECT SUM(antalStemmer) FROM svar WHERE afstemningsnr=$nr");
$row = mysql_fetch_array($result);
$sum = $row["SUM(antalStemmer)"];

$result = mysql_query("SELECT svar, antalStemmer FROM svar WHERE afstemningsnr=$nr ORDER BY indeks");

while($row = mysql_fetch_array($result))
{ $svar = $row["svar"];
$antalStemmer = $row["antalStemmer"];

$procentTal = round(($antalStemmer / $sum * 100), 0);

print "<img border='0' src='/grafik/afstand.gif' width='4' height='1'>$svar<br>";
print "<img border='0' src='/grafik/afstand.gif' width='4' height='11'><img border='0' src='/grafik/afstemningsbar.gif' width='".($procentTal * 1.57)."' height='10'>  $procentTal%<br>";
print "<img border='0' src='/grafik/afstand.gif' width='1' height='2'><br>";
}

print "<p align='center'><font size='1' face='Verdana' color='#000000'>Antal stemmer: $sum</font></p>";

}

print "</tr>";
print "</table>";
print "</center>";
print "</div>";

?>

<p align="center"><font face="Verdana" size="1" color="#000000"><a href='/afstemning/tidligere_afstemninger.php'>Tidligere afstemninger</a><br>
<br>
</font></p>

</td>
</tr>
<tr>
<td width="100%" align="center"><hr size="1" color="#000000"><font face="Verdana" size="1" color="#000000"><br>
<script language="JavaScript1.2">document.write(text)</script></font></td>
</tr>
</table>

</body>

</html>

stem.php:
<?php

if (isset($_POST["afstemning"]))
{
$connection = mysql_connect("**--**","**--**","**--**");
$db = "**--**";
mysql_select_db($db);

$result = mysql_query("SELECT nr FROM afstemning ORDER BY nr DESC");

$row = mysql_fetch_array($result);
$nr = $row["nr"];

setcookie("harStemt", $nr, time()+60*60*24*31, "/");
}

?>

<html>
<head>
<title>**--**</title>
</head>

<body>


<?php

if (isset($_POST["afstemning"]))
{
mysql_query("UPDATE svar SET antalStemmer=antalStemmer+1 WHERE afstemningsnr=$nr AND indeks=".$_POST["afstemning"]);
}

?>


<SCRIPT LANGUAGE="JavaScript1.2">
<!--

location.href='<?php print "/afstemning/index.php"; ?>'

// -->
</SCRIPT>


</body>
</html>