Train time-table for station

"; mysql_connect($db_server,$user,$pwd); $pr_query="Select * from prices_e where city='$st_name'"; $pr_res=mysql($db, $pr_query); $pr_numr=mysql_numrows($pr_res); If($pr_numr>0) {echo "
Prices from Ternopol to ".$st_name."
"; If(mysql_result($pr_res,0,"plackart")<>"") {echo "Car with reserved seats: ". mysql_result($pr_res,0,"plackart")." UAH.
"; } If(mysql_result($pr_res,0,"kupe")<>"") {echo "Compartment: ". mysql_result($pr_res,0,"kupe")." UAH."; } If(mysql_result($pr_res,0,"sv")<>"") {echo "Sleeping-car: ". mysql_result($pr_res,0,"sv")." UAH."; } echo "

"; } If($sort_by1 == "") { $sort_by1="st.outtime"; } // 1 признак сортировки switch ($sort_by) { case "st.trainnumber": $sort_str="train number"; break; case "r.startpoint": $sort_str="start station"; break; case "r.stoppoint": $sort_str="end station"; break; case "st.intime": $sort_str="arrival time"; break; case "st.outtime": $sort_str="departure time"; break; default: $sort_str="arrival time"; $sort_by="st.intime"; } // 2 признак сортировки switch ($sort_by1) { case "st.trainnumber": $sort_str=$sort_str.", train number)"; break; case "r.startpoint": $sort_str=$sort_str.", start station"; break; case "r.stoppoint": $sort_str=$sort_str.", end station"; break; case "st.intime": $sort_str=$sort_str.", arrival time"; break; case "st.outtime": $sort_str=$sort_str.", departure time"; break; default: $sort_str=$sort_str; } $query="select st.trainnumber, st.intime, st.outtime, st.stoptime, st.workday, r.rootnumber, r.startpoint, r.stoppoint, r.traintype from stations st, roots r where st.stationname='$st_name' and st.trainnumber=r.rootnumber and ( (st.outtime>='$start_time' or '$start_time'=\"\") and (st.outtime<='$stop_time' or '$stop_time'=\"\") or ( st.outtime=\"-\" and (st.intime>='$start_time' or '$start_time'=\"\") and (st.intime<='$stop_time' or '$stop_time'=\"\") ) ) order by $sort_by, $sort_by1"; //echo "--".$query; $res=mysql($db, $query); $numr=mysql_numrows($res); echo " Trains found: ".$numr."       Sort by: ".$sort_str.""; echo "
"; for($i=0; $i" : ""; $tr_num=mysql_result($res,$i,"trainnumber"); $tr_num_ur=urlencode($tr_num); echo ""; $instation=mysql_result($res,$i,"startpoint"); $instation_ur=urlencode($instation); echo ""; $outstation=mysql_result($res,$i,"stoppoint"); $outstation_ur=urlencode($outstation); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Train
##
Dep. station Arr. station Arrival
time
Departure
time
Stop
time
Train
type
Periodicity
"."

$tr_num

"."
"."

$instation

"."
"."

$outstation

"."
".mysql_result($res,$i,"intime")."".mysql_result($res,$i,"outtime")."".mysql_result($res,$i,"stoptime")."".mysql_result($res,$i,"traintype")."".mysql_result($res,$i,"workday")."
"; echo "
"; mysql_close(); ?>