|
List of special Ukrainian railway sites in Internet.
error_reporting(0);
include("accessr.php3");
require ("edit_ru.php3");
mysql_connect($db_server,$user,$pwd) or $mail_me;
mysql_select_db($db) or $mail_me;
switch ($showtype) { // choose what kind of view
case "all":
$query = "SELECT city,site_eng, site_url, text_eng, site_img, site_click, site_lang ,bad_link
from uarailway order by city_en";
$mysee="Complete list of Ukraine railway sites";
break;
case "cities":
$query = "SELECT city_en,site_eng, site_url, text_eng, site_img, site_click, site_lang ,bad_link
from uarailway where city_en='$whatcity' order by site_eng";
$mysee="Review of railway site(s) in ".$whatcity." city";
break;
case "categoria":
$query = "SELECT city_en,site_eng, site_url, text_eng, site_img, site_click, site_lang ,bad_link
from uarailway where categor_en='$whatcat' order by city_en";
$mysee="Review of site following category: ".$whatcat;
break;
case "request":
$query = "SELECT city_en, site_eng, site_url, text_eng, site_img, site_click, site_lang ,bad_link
from uarailway where categor_en='$whatcat' and city_en='$whatcity' order by site_eng";
$mysee="Review of site following category: ".$whatcat." in the ".$whatcity." city ";
break;
default: { $query = "SELECT city_en,site_eng, site_url, text_eng, site_img, site_click, site_lang, bad_link
from uarailway order by city_en";
$mysee="All Ukrainian sites";
}
}
?>
// =========Cycle of view===========
// query was define before
$res = mysql_query($query);
$numr=mysql_numrows($res);
echo "Sites found: ".$numr;
for($i=0; $i
";
if ($showtype=="cities")
{echo "".$name." "."URL: "."".$site_url." ".
" ".$language."";
if (mysql_result($res,$i,"bad_link")=="bad") {echo " URL don't work.";}
echo "
".$opis;}
if ($showtype=="categoria" or $showtype=="all" or $showtype=="" or $showtype=="request")
{echo "City: ".$gorod." ".$name." "."URL: "."".$site_url." ".
" ".$language."";
if (mysql_result($res,$i,"bad_link")=="bad") {echo " URL don't work.";}
echo "
".$opis;
}
echo " | ";
$img=eregi_replace( "\"", "'", $name); // replace of qoutes "
echo "";
echo " |
|
|