Gäste am SAI
// includes include("projects/gaeste/conf.php"); // open database connection $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); // generate and execute query $query = "SELECT id, guest_titel, guest_name, guest_surname, where_from, status, sai_room, phone, arrival_day, departure_day, arrival_month, departure_month, arrival_year, departure_year, Host_IP, ServerTime, online, sai_contact , department , email FROM sai_guests WHERE online = 'ja' ORDER BY guest_name ASC"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); $heute = date("Y-m-d"); // if records present if (mysql_num_rows($result) > 0) { // iterate through resultset // print title with links to edit and delete scripts while($row = mysql_fetch_object($result)) { ?>
echo $row->guest_titel; ?> echo $row->guest_name; ?>, echo $row->guest_surname; ?>
echo $row->status; ?> |
||||
|
||||
} } // if no records present // display message else { ?> Zur Zeit keine Gäste am SAI
} // close connection mysql_close($connection); ?>
Seitenbearbeiter: E-Mail