rendered paste body<?php
// im getting the following values out of my database, reading out as array:
/*
villa_id villa_naam avail_id week_nummer
1 Villa Hortensias 1 5
1 Villa Hortensias 1 42
2 Villa Costa 1 8
2 Villa Costa 1 12
2 Villa Costa 1 20
2 Villa Costa 1 51
*/
while ($row_villa = dbFetchArray($result_villa))
{
print_r(array_values($row_villa));
echo "<br />";
}
/*
output:
Array ( [0] => 1 [1] => Villa Hortensias [2] => 1 [3] => 5 )
Array ( [0] => 1 [1] => Villa Hortensias [2] => 1 [3] => 42 )
Array ( [0] => 3 [1] => Villa Costa [2] => 1 [3] => 8 )
Array ( [0] => 3 [1] => Villa Costa [2] => 1 [3] => 12 )
Array ( [0] => 3 [1] => Villa Costa [2] => 1 [3] => 20 )
Array ( [0] => 3 [1] => Villa Costa [2] => 1 [3] => 51 )
now i need to get the following which i cant get to work:
1 table with 52 weeks:
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 1 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Villa Costa: 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 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 0 0 0 0 0 0 0 0 0 0 1 0
Im stuck with making the array.
*/
?>