|
Стоимость проезда от станции Тернополь (лето 2007)
require ("accessr.php3");
mysql_connect($db_server,$user,$pwd);
if($sorting2 == "") { $sorting2 = "city";}
switch ($sorting2) {
case "city": $getSort = "station"; break;
case "plackart": $getSort = "plackart"; break;
case "kupe": $getSort = "kupe"; break;
case "sv": $getSort = "sv"; break;
case "comment": $getSort = "obshiy"; break;
default: $getSort = "station";
}
if($sortorder == "desc") { $SetOrderWay = "desc"; $NextOrder = "asc";}
if($sortorder == "asc") { $SetOrderWay = "asc"; $NextOrder = "desc";}
if($sortorder == "") { $SetOrderWay = "desc"; $NextOrder = "asc";}
If($st_name=="Все станции" or $st_name=="")
{
//$query="select city, plackart,kupe,sv,comment from price_tern group by city order by city";
$query="SELECT * from prices2007 ORDER by $getSort $SetOrderWay";
}
$res=mysql($db, $query);
$numr=mysql_numrows($res);
$ssft_myusd=$usd; //1$ rate from NBU
$myusd=$usd;
$myusd="5,05";
if ($money=="usd")
{echo " Станций найдено: ".$numr."Цена в долларах.Курс:1$=$myusd. Подсчитать цену в гривнях.";}
else
{echo " Станций найдено: ".$numr."Цена в гривнях. Подсчитать цену в долларах (курс НБУ).";}
echo "
";
if ($sorting2=="city")
{echo" Название станции
| ";}
else
{echo" Название станции | ";}
if ($sorting2=="plackart")
{echo" Плацкарт | ";}
else
{echo" Плацкарт | ";}
if ($sorting2=="kupe")
{echo" Купе | ";}
else
{echo" Купе | ";}
if ($sorting2=="sv")
{echo" СВ | ";}
else
{echo" СВ | ";}
if ($sorting2=="comment")
{echo" Комментарии | ";}
else
{echo" Общий | ";}
echo " ";
for($i=0; $i" : "";
$st_name=mysql_result($res,$i,"station");
$st_name_ur=urlencode($st_name);
echo ""."$st_name"." (поезд N".mysql_result($res,$i,"train").") | ";
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")." | ";}
}
}
if ($money=="usd" and mysql_result($res,$i,"obshiy")!="0.00")
{echo "".round(mysql_result($res,$i,"obshiy")/$myusd)." | ";}
else
{
if ($money=="uah" and mysql_result($res,$i,"obshiy")!="0.00") {echo "".mysql_result($res,$i,"obshiy")." | ";}
else
{
if (mysql_result($res,$i,"obshiy")=="0.00") {echo "- | ";}
else {echo "".mysql_result($res,$i,"obshiy")." | ";}
}
}
}
echo " ";
echo " |
";
mysql_close();
?>
|