|
include("google.php3"); ?>
Travel prices from Ternopol station.
The table of a travel expenses at suburban
trains.
require ("accessr.php3");
mysql_connect($db_server,$user,$pwd);
If($sorting2 == "") { $sorting2="city_en"; }
If($st_name=="All stations" or $st_name=="")
{
//$query="select city_, plackart,kupe,sv,comment from price_tern group by city order by city";
$query="select city_en, plackart,kupe,sv,comment_en from price_tern group by city_en order by $sorting2";
}
else
{
// $query="select city, plackart,kupe,sv,comment from price_tern where city='$st_name' group by city";
// $par_ur=urlencode("Все станции");
// echo " Стоимость проезда
// для всех станций";
}
$res=mysql($db, $query);
$numr=mysql_numrows($res);
// extract from SSFT script
//include "/home/www/ssft/usd.php3";
//$ssft_myusd=$usd; //1$ rate from NBU
//$ssft_myusd="5.4189";
$myusd="5,3";
$myusd=$usd;
//eregi_replace("\\.",",", $ssft_myusd);
/*
if ($money=="usd")
{echo " Stations found: ".$numr."Price in USD. Rate:1$=$myusd. Show price in UAH.";}
else
{
*/
echo " Stations found: ".$numr."Price in UAH.";
// Show price in USD (NBU rate).";}
echo "
";
if ($sorting2=="city_en")
{echo" Station
[sorted] | ";}
else
{echo" Station | ";}
if ($sorting2=="plackart")
{echo" reserved seat
[sorted] | ";}
else
{echo" reserved seat | ";}
if ($sorting2=="kupe")
{echo" compartment
[sorted] | ";}
else
{echo" compartment | ";}
if ($sorting2=="sv")
{echo" soft-seated
[sorted] | ";}
else
{echo" soft-seated | ";}
if ($sorting2=="comment_en")
{echo" commentи
[sorted] | ";}
else
{echo" comment | ";}
echo " ";
for($i=0; $i" : "";
$st_name=mysql_result($res,$i,"city_en");
$st_name_ur=urlencode($st_name);
echo ""."$st_name"." | ";
if ($money=="usd" and mysql_result($res,$i,"plackart")!="0.00")
{echo "".round(mysql_result($res,$i,"plackart")/$myusd)." | ";}
else
{
if ($money=="uah" and mysql_result($res,$i,"plackart")!="0.00" and $money!="uah") {echo "".mysql_result($res,$i,"plackart")." | ";}
else
{
if (mysql_result($res,$i,"plackart")=="0.00") {echo "- | ";}
else {echo "".mysql_result($res,$i,"plackart")." | ";}
}
}
if ($money=="usd" and mysql_result($res,$i,"kupe")!="0.00")
{echo "".round(mysql_result($res,$i,"kupe")/$myusd)." | ";}
else
{
if ($money=="uah" and mysql_result($res,$i,"kupe")!="0.00") {echo "".mysql_result($res,$i,"kupe")." | ";}
else
{
if (mysql_result($res,$i,"kupe")=="0.00") {echo "- | ";}
else {echo "".mysql_result($res,$i,"kupe")." | ";}
}
}
if ($money=="usd" and mysql_result($res,$i,"sv")!="0.00")
{echo "".round(mysql_result($res,$i,"sv")/$myusd)." | ";}
else
{
if ($money=="uah" and mysql_result($res,$i,"sv")!="0.00") {echo "".mysql_result($res,$i,"sv")." | ";}
else
{
if (mysql_result($res,$i,"sv")=="0.00") {echo "- | ";}
else {echo "".mysql_result($res,$i,"sv")." | ";}
}
}
echo "".mysql_result($res,$i,"comment_en")." | ";
}
echo " ";
echo " |
";
mysql_close();
?>
|