hvorfor virker tælleren ikke?
Hej kan i hjælpe mig med at se hvad der er galt i denne tæller?<?php
$aarstal = array();
$detteaar = date("y");
$aarstalquery1 = mysql_query("SELECT * FROM taeller WHERE aar='$detteaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow1 = mysql_fetch_assoc($aarstalquery1)) {
array_push($aarstal, $aarstalrow1['aar']);
}
$sidsteaar = $detteaar-1;
$aarstalquery2 = mysql_query("SELECT * FROM taeller WHERE aar='$sidsteaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow2 = mysql_fetch_assoc($aarstalquery2)) {
array_push($aarstal, $aarstalrow2['aar']);
}
$forrigeaar = $detteaar-2;
$aarstalquery3 = mysql_query("SELECT * FROM taeller WHERE aar='$forrigeaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow3 = mysql_fetch_assoc($aarstalquery3)) {
array_push($aarstal, $aarstalrow3['aar']);
}
$maanedstal = array();
if(isset($_GET['aar'])) $aar = $_GET['aar'];
else $aar = date("Y");
for($i = 1; $i < 13; $i++) {
array_push($maanedstal, mysql_num_rows(mysql_query("SELECT * FROM taeller WHERE maaned='$i' AND aar='$aar'")));
}
?>
<script type="text/javascript">
<?
print "var months = [";
$maaned = 0;
foreach($maanedstal as $mt) {
$maaned++;
if($maaned != 12) print $mt.",";
else print $mt;
}
print "];";
?>
function visNummer(sel) {
sel.form.textfelt.value = months[sel.selectedIndex];
}
?>
</script>
<select name="aar" onChange="window.location.href='<?= $_SERVER['PHP_SELF'] ?>?aar='+this.value;">
<?php
for($i = $aarstal[count($aarstal)]; $i > 0; $i--) {
print "<option value=\"".$aarstal[$i]."\">".$aarstal[$i]."</option>";
}
?>
</select>
<script type = "text/javascript">
document.getElementById('aarselector').value = "<?= $aar ?>";
</script>
<form name="monthcount">
<select name="maaneder" onChange="visNummer(this);">
<option value="januar">Januar</option>
<option value="februar">Februar</option>
<option value="marts">Marts</option>
<option value="april">April</option>
<option value="maj">Maj</option>
<option value="juni">Juni</option>
<option value="juli">Juli</option>
<option value="august">August</option>
<option value="september">September</option>
<option value="oktober">Oktober</option>
<option value="november">November</option>
<option value="december">December</option>
</select>
<input type="hidden" name="textfelt" size="5">
</form>
<?
$query = mysql_query("SELECT nr FROM taeller ORDER BY nr DESC LIMIT 1") or die(mysql_error());
if($row = mysql_fetch_assoc($query)) $nr = $row['nr'];
echo "Der har været $nr besøgende";
?><br>
<br>
<?php
if(isset($_POST['slet'])) {
$slet = $_POST['slet'];
if($slet == "jeps") {
require "db.php";
mysql_query("TRUNCATE TABLE taeller");
print "Tabellen taeller er tømt max";
}
}
?>
<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="slet" value="jeps">
<input type="submit" value="Nulstil">
</form>
det har noget med:
$aarstal = array();
$detteaar = date("y");
$aarstalquery1 = mysql_query("SELECT * FROM taeller WHERE aar='$detteaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow1 = mysql_fetch_assoc($aarstalquery1)) {
array_push($aarstal, $aarstalrow1['aar']);
}
$sidsteaar = $detteaar-1;
$aarstalquery2 = mysql_query("SELECT * FROM taeller WHERE aar='$sidsteaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow2 = mysql_fetch_assoc($aarstalquery2)) {
array_push($aarstal, $aarstalrow2['aar']);
}
$forrigeaar = $detteaar-2;
$aarstalquery3 = mysql_query("SELECT * FROM taeller WHERE aar='$forrigeaar' ORDER BY aar LIMIT 0, 1");
if($aarstalrow3 = mysql_fetch_assoc($aarstalquery3)) {
array_push($aarstal, $aarstalrow3['aar']);
}
$maanedstal = array();
if(isset($_GET['aar'])) $aar = $_GET['aar'];
else $aar = date("Y");
for($i = 1; $i < 13; $i++) {
array_push($maanedstal, mysql_num_rows(mysql_query("SELECT * FROM taeller WHERE maaned='$i' AND aar='$aar'")));
}
?>
som er øverst.
Håber i kan hjælpe.
