0) { while($row = mysqli_fetch_array($result)) { $result2 = $db->query("SELECT date_format(tm_datum, '%d.%m.%Y - %H:%i Uhr') tm_datum_form, tm_datum FROM dvm_term_kand a, dvm_termine b WHERE a.tm_id = b.tm_id AND a.ka_id = '$row[ka_id]' ORDER BY tk_id DESC LIMIT 1"); $row2 = $result2->fetch_array(); if($row2['tm_datum'] == '0000-00-00 00:00:00'){ $tm_datum_form = "-"; }else{ $tm_datum_form = $row2['tm_datum_form']; } if(mysqli_num_rows($result) == 1){ $output .= " "; }else{ $output .= " "; } } echo $output; } else { echo 'Data Not Found'; } ?>