name | end date | start date | interface number DM2D 1293714000 995896800 01/00 DM2D 1293714000 1106830800 01/01 DM2D 1231074000 1231074000 02/00 DM2D 1239890400 1237813200 02/00 DM2D 1244296800 1241359200 02/00 DM2D 1247407200 1244469600 02/00 DM2D 1293714000 1071061200 02/01 DM2D 1293714000 1011272400 03/00 DM2D 1293714000 1011272400 03/01 DM2D 1293714000 996415200 04/00 DM2D 1293714000 996415200 04/01 DM2D 1293714000 996415200 04/02 DM2D 1293714000 996415200 04/03 DM2D 1293714000 996415200 04/04 DM2D 1293714000 996415200 04/05 DM2D 1293714000 996415200 04/06 DM2D 1293714000 996415200 04/07 DM2D 1293714000 996415200 05/00 DM2D 1293714000 996415200 05/01 DM2D 1293714000 996415200 05/02 DM2D 1293714000 996415200 05/03 DM2D 1293714000 996415200 05/04 DM2D 1293714000 996415200 05/05 DM2D 1293714000 996415200 05/06 DM2D 1230642000 996415200 05/07 DM2D 1293714000 1248876000 05/07 DM2D 1293714000 1011272400 06/00 DM2D 1293714000 1011272400 06/01 DM2D 1227618000 1227445200 07/00 DM2D 1229518800 1228914000 07/00 DM2D 1244383200 1244124000 07/00 DM2D 1264856400 1246802400 08/00 DM2D 1293714000 1126015200 08/01 DM2D 1238421600 1229259600 08/02 DM2D 1264856400 1246802400 08/02 DM2D 1238421600 1229259600 08/03 DM2D 1238421600 1229259600 08/04 DM2D 1243346400 1240754400 08/04 DM2D 1238421600 1232888400 08/05 DM2D NULL NULL 08/06 DM2D NULL NULL 08/07 DM2D 1293714000 1075208400 08/08 DM2D 1293714000 1075208400 08/09 DM2D 1293714000 1075726800 08/10 DM2D 1293714000 1085666400 08/11 DM2D 1293714000 1085666400 08/12 DM2D 1293714000 1085666400 08/13 DM2D 1293714000 1085666400 08/14 DM2D 1293714000 1092578400 08/15 DM2D 1293714000 1119448800 08/16 DM2D 1293714000 1092578400 08/17 DM2D 1248962400 1235307600 08/18 DM2D 1248962400 1235307600 08/19 DM2D 1248962400 1235307600 08/20 DM2D 1239890400 1237899600 08/21 DM2D 1239890400 1237899600 08/22 DM2D 1247407200 1243519200 08/22 DM2D 1293714000 1100782800 08/23 DM2D 1239890400 1238940000 08/24 DM2D 1293714000 1098885600 08/25 DM2D 1293714000 1124114400 08/26 DM2D 1293714000 1105966800 08/27 DM2D 1293714000 1105966800 08/28 DM2D 1235739600 1232283600 08/29 DM2D NULL NULL 08/30 DM2D NULL NULL 08/31 DM2D NULL NULL 09/00 DM2D 1293714000 1008853200 10/00 DM2D NULL NULL 10/01 DM2D NULL NULL 10/02 DM2D NULL NULL 10/03 DM2D NULL NULL 10/04 DM2D NULL NULL 10/05 SELECT schedules.scheduletitle, resources.name, reservations.summary, reservations.end_date, reservations.start_date FROM schedules LEFT OUTER JOIN resources ON schedules.scheduleid = resources.scheduleid LEFT OUTER JOIN reservations ON resources.machid = reservations.machid WHERE schedules.scheduletitle = 'dm2d' AND (reservations.end_date >= $today_date OR reservations.end_date IS NULL) ORDER BY resources.name --------------------------------------------------- I am trying making a booking viewing form. That script will print out all none booking interface and current booking. The issue is that script will filter out some has booked but was expired interfaces. If I want to print all the "null", all current not expire booking and available interfaces (these booking been expired) but not all history. Can any one able to help me please?