also visit  my personal website   |   Photography   |   Books (Dutch)   |   Expedition Kilimanjaro   |   the European Cooking Trip

Reports

-->"; require("../global.php"); $link = mysql_connect($host, $user, $pass); @mysql_select_db($name, $link); # Get the previous ID.. $sql = "SELECT id FROM $tabel1 WHERE id < $current_report ORDER BY id DESC LIMIT 1"; $result = mysql_query($sql,$link) or die(mysql_error() . " query: " . $sql); if (mysql_num_rows($result) > 0) { $myrow = mysql_fetch_row($result); $vorige_report = $myrow[0]; } else { $vorige_report = -1; } # Get the next ID... $sql = "SELECT id FROM $tabel1 WHERE id > $current_report ORDER BY id ASC LIMIT 1"; $result = mysql_query($sql,$link) or die(mysql_error() . " query: " . $sql); if (mysql_num_rows($result) > 0) { $myrow = mysql_fetch_row($result); $volgende_report = $myrow[0]; } else { $volgende_report = -1; } # Finally, print the menu: ### Left ### if ($vorige_report >= 0) { print <<« Previous report EOF; } else { print <<All reports EOF; ### Right ### if ($volgende_report >= 0) { print <<Next report » EOF; } else { print << 988667999" ; $results = mysql_db_query($name,$query ,$connection); $counter = mysql_result($results,0); $GetStmt = "SELECT * FROM $tabel1 ORDER BY id DESC" ; $link=mysql_connect($host, $user, $pass); @mysql_select_db($name, $link); $result=mysql_query($GetStmt, $link); while ($row = mysql_fetch_object($result)){ $id = $row->id; $locatie = $row->onderwerp; $tijd = $row->tijd; $kop = $row->kop; $report = $row->report; $dag = date("j M Y", $tijd); printf("$dag: $locatie
"); } ?> id; $locatie = $row->onderwerp; $tijd = $row->tijd; $kop = $row->kop; $report = $row->report; $dayb = $id - 1; $dag = date("l", $tijd); $dag1 = date("j", $tijd); $maand = date("F", $tijd); $year = date("Y", $tijd); $report = stripslashes($report); $kop = stripslashes($kop); ?>