rendered paste body// loop unique ID's
foreach($arrAll_unique_ids as $currentvilla){
$tdrow = '';
$villaname = '';
// loop data DB rows
foreach($arrAll_villas as $villa_data){
if($villa_data[1] == $currentvilla){
$villaname = $villa_data[0];
for($i=1;$i<=52;$i++){
if($villa_data[3] == $i){
$tdrow .= '<td>'.$arrAll_villas[$key][3].'</td>';
}
else {
$tdrow .= '<td>-</td>';
}
}
}
}
$output = '<table>';
$output .= '<tr><td colspan="20">'.$villaname.'</td></tr>';
$output .= '<tr>'.$tdrow.'</tr>';
$output .= '</table><br><br>';
$table = $output;
}
echo $table;