Logged in as: $username

"; $sql = sql_query("select * from $tbl_entry WHERE name='$username' ORDER BY start_time"); #$res=mysql_fetch_row($sql); #$row = sql_row($sql, 0); $i = 1; $nofilter = $_GET[showexpired]; $showdata = 1; $checkbooking = 0; while ($row=mysql_fetch_row($sql)){ $this_room_name = sql_query1("select room_name from $tbl_room where id=$row[5]"); #check if the booking is upcoming if (($row[1] < date(U)) && ($i < 1000)) { $i++; if ($nofilter == 1) { #show expired $showdata = 1; echo ""; } else { $showdata = 0; } } else { $showdata = 1; echo ""; } if ($showdata == 1) { $checkbooking = 1; echo " "; } } if ($checkbooking == 0) { echo ""; } echo "

Upcoming Bookings (next 50)
Date	Time	Resource	Description	More...	Edit	Del
"; echo date("D, F j, Y", $row[1]); echo "	"; echo period_time_string($row[1]); echo "	$this_room_name	$row[10]	click	click	click
No upcoming bookings found

"; ?>