Unnamed

<?php

if (!isset($_POST['cboVilla']))
{
	$villa_id = $_GET['villa_id'];
}
else
{
	$villa_id = $_POST['cboVilla'];
}

// selecteer villa uit de database
$sql_villa =	"SELECT v.villa_naam,
							vb.beschikbaarheid, vb.week_nummer
							FROM villa_beschikbaarheid vb, villa v
							WHERE vb.villa_id = v.villa_id
							
						 ";
$result_villa = dbQuery($sql_villa);
//WHERE vb.villa_id = $villa_id
//AND vb.villa_id = v.villa_id
?>

<div id="add_afstandvilla">
<a href="<?php echo WEB_ROOT_ADMIN; ?>afstandvilla/index.php?view=toevoegen&amp;villa_id=<?php echo $villa_id; ?>">Afstand tot op deze villa toevoegen</a>
</div>

<div id="list_afstandvilla">
<?php
if (!isset($_GET['villa_id']))
{
	echo '<h2>Weergeven</h2>' . NEW_LINE;
}
?>
<table width="100%" border="1" align="center">
<tr>
<?php

$arrVilla = array();

while ($row_villa = dbFetchArray($result_villa))
{
 array_push($arrVilla, $row_villa[0], $row_villa[1], $row_villa[2]);
}

print_r(array_values($arrVilla));

$id = 2;

if (array_key_exists($id, $arrVilla))
{
echo'
<table border=1>
<tr>
<td>weeknumber:</td>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
<td>13</td>
<td>14</td>
<td>15</td>
<td>16</td>
<td>17</td>
<td>18</td>
<td>19</td>
<td>20</td>
<td>21</td>
<td>22</td>
<td>23</td>
<td>24</td>
<td>25</td>
<td>26</td>
<td>27</td>
<td>28</td>
<td>29</td>
<td>30</td>
<td>31</td>
<td>32</td>
<td>33</td>
<td>34</td>
<td>35</td>
<td>36</td>
<td>37</td>
<td>38</td>
<td>39</td>
<td>40</td>
<td>41</td>
<td>42</td>
<td>43</td>
<td>44</td>
<td>45</td>
<td>46</td>
<td>47</td>
<td>48</td>
<td>49</td>
<td>50</td>
<td>51</td>
<td>52</td>
</tr>';



	echo '<tr>';
	echo '<td>' . $arrVilla[0] . '</td>';
	for ($weekId = 1; $weekId <= 52; $weekId++)
	{
		if ($weekId == $arrVilla[$id])
		{
			echo '<td>' . $arrVilla[$id] . '</td>';
			$id = $id + 3;
			if (!array_key_exists($id, $arrVilla))
			{
				for ($weekId = $weekId; $weekId <= 51; $weekId++)
				{
					echo '<td>0</td>';
				}
			}
		}
		else
		{
			echo '<td>0</td>';
		}
	}
echo'</tr>';
echo'</table>';
}
else
{
echo'geen beschikbaarheid aanwezig';
}



?>
</tr>
</table>
</div>

<?php
/*
output:
Array ( [0] => Villa Hortensias [1] => 1 [2] => 5 [3] => Villa Hortensias [4] => 1 [5] => 42 [6] => Villa Costa [7] => 1 [8] => 8 [9] => Villa Costa [10] => 1 [11] => 12 [12] => Villa Costa [13] => 1 [14] => 20 [15] => Villa Costa [16] => 1 [17] => 51 )  
weeknumber: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 
Villa Hortensias 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0 

*/
?>
// out