<?php
function sql($query)
{
  $link = mysql_pconnect("mysql.nehlsen.se", "motion", "alskling")
    or die("Could not connect");
  mysql_select_db("motion")
    or die("Could not select database");
  // Performing SQL query
  $result = mysql_query($query)
    or die("Query $query failed");
  return $result;
}


function weekdays($startdate)
{
  $resultat=sql("select DATE_ADD(DATE(DATE_SUB('" . $startdate . "', INTERVAL 1 DAY)), INTERVAL 1 DAY) as wstart");
  $w=mysql_fetch_assoc($resultat);
  $wstart=$w['wstart'];
  $resultat=sql("select DATE_ADD(DATE(DATE_SUB('" . $startdate . " 23:59:59', INTERVAL 1 DAY)), INTERVAL 7 DAY) as wend");
  $w=mysql_fetch_assoc($resultat);
  $wend=$w['wend'];
  $week=array($wstart, $wend);
  return $week;
 // echo $wstart . "  " . $wend;
}

?>
<script language="JavaScript" type="text/JavaScript"><!--


function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v6.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>

<div id="mandaer" style="position:absolute; left:112px; top:16px; width:232px; height:161px; z-index:1">
  <table width="200" border="0">
    <tr>
      <td><a href="javascript:;" onClick="MM_showHideLayers('mandaer','','show','juni','','show','juli','','hide','aug','','hide','tillbaka','','show','streck','','show','cirekl','','show')"><img src="hemsida/juniwebb.gif" width="65" height="43" border="0"></a></td>
    </tr>
    <tr>
      <td><a href="javascript:;" onClick="MM_showHideLayers('mandaer','','show','juni','','hide','juli','','show','aug','','hide','tillbaka','','show','streck','','show','cirekl','','show')"><img src="hemsida/juliwebb.gif" width="57" height="40" border="0"></a></td>
    </tr>
    <tr>
      <td><a href="javascript:;" onClick="MM_showHideLayers('mandaer','','show','juni','','hide','juli','','hide','aug','','show','tillbaka','','show','streck','','show','cirekl','','show')"><img src="hemsida/augwebb.gif" width="106" height="53" border="0"></a></td>
    </tr>
  </table>
</div>
<div id="juni" style="position:absolute; left:113px; top:249px; width:282px; height:234px; z-index:2; visibility: hidden;">
  <table width="200" border="0" cellspacing="20" bordercolor="#666666">
    <tr>
      <td>&nbsp;</td>
      <td><img src="hemsida/mariawebb.gif" width="102" height="44"></td>
      <td><img src="hemsida/mikaelwebb.gif" width="111" height="44"></td>
    </tr>
    <tr>
      <td>V.25</td>
      <?php
        $weekstart='2008-06-16';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.26</td>
      <?php
        $weekstart='2008-06-23';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.27</td>
      <?php
        $weekstart='2008-06-30';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
</div>
<div id="juli" style="position:absolute; left:113px; top:249px; width:345px; height:227px; z-index:3; visibility: hidden;">
  <table width="200" border="0" cellspacing="20">
    <tr>
      <td>&nbsp;</td>
      <td><img src="hemsida/mariawebb.gif" width="102" height="44"></td>
      <td><img src="hemsida/mikaelwebb.gif" width="111" height="44"></td>
    </tr>
    <tr>
      <td>V.27</td>
      <?php
        $weekstart='2008-06-30';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.28</td>
      <?php
        $weekstart='2008-07-07';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.29</td>
      <?php
        $weekstart='2008-07-14';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.30</td>
      <?php
        $weekstart='2008-07-21';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.31</td>
      <?php
        $weekstart='2008-07-28';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
  </table>
</div>
<div id="aug" style="position:absolute; left:113px; top:249px; width:400px; height:240px; z-index:4; visibility: hidden;">
  <table width="200" border="0" cellspacing="20">
    <tr>
      <td>&nbsp;</td>
      <td><img src="hemsida/mariawebb.gif" width="102" height="44"></td>
      <td><img src="hemsida/mikaelwebb.gif" width="111" height="44"></td>
    </tr>
    <tr>
      <td>V.31</td>
      <?php
        $weekstart='2008-07-28';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.32</td>
      <?php
        $weekstart='2008-08-04';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.33</td>
      <?php
        $weekstart='2008-08-11';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.34</td>
      <?php
        $weekstart='2008-08-18';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
    <tr>
      <td>V.35</td>
      <?php
        $weekstart='2008-08-25';
        $weekdays=weekdays($weekstart);
        $result=sql("select sum(steg) as day from steg where datum>='" . $weekdays[0] . "' and datum<='" . $weekdays[1] . "' group by user order by user asc");
        while ($temp=mysql_fetch_assoc($result))
        {
          echo '<td><div align="center">' . $temp['day'] . "</div></td>";
        }
      ?>
    </tr>
  </table>
</div>
<div id="tillbaka" style="position:absolute; left:613px; top:429px; width:119px; height:75px; z-index:10; visibility: visible;"><a href="stegraknare2.php"><img src="hemsida/backwebb.gif" width="163" height="53" border="0"></a></div>
<div id="streck" style="position:absolute; left:78px; top:156px; width:80px; height:37px; z-index:7; visibility: visible;"><img src="hemsida/streckwebb.gif" width="712" height="126"></div>
<div id="cirekl" style="position:absolute; left:565px; top:363px; width:72px; height:37px; z-index:9; visibility: visible;"><img src="hemsida/cirektlwebb.gif" width="256" height="181"></div>
