All pastes #73218 Raw Edit

Untitled

public text v1 · immutable
#73218 ·published 2006-06-27 16:11 UTC
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.
*/
?>