......................................................................................... = ".$now." order by startdate"; $result = mysql_query($sqlstmt); if (!$result){ echo mysql_error(); exit; } $r=0; if(mysql_numrows($result)==0){ echo "\r\n"; }else{ while ($row = mysql_fetch_assoc($result)) { $from=$row["from"]; $to=$row["to"]; $row["enddate"]=($row["enddate"]==$row["startdate"] ? "" : $row["enddate"]); $daterange=strftime("%m/%d/%y",$row["startdate"]).($row["enddate"] ? "-".strftime("%m/%d/%y",$row["enddate"]) : ""); $description=$row["description"]; $capacity=$row["capacity"]; $style=($row["highlight"]=="TRUE" ? "_hi" : ""); print($r%2 ? "\r\n" : "\r\n"); print("\r\n"); print("\r\n"); $r++; } } @mysql_free_result($num_result); }else{ PRINT("ERROR SELECTING DATABASE "); } mysql_close($link); }else{ print("No link "); } ?> From To Dates Plane Passenger Capacity ".$no_trips_msg." ".$from." ".$to." ".$daterange." ".$description." ".$capacity." ......................................................................................... home • corporate • see the world • fleet • service • safety • about us • contact us • specials • certifications