|
Обзор Украинских ж.д. сайтов.
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_name, site_url, site_text, site_img, site_click, site_lang, bad_link
from uarailway order by city";
$mysee="Весь список Украинских ж.д. сайтов";
break;
case "cities":
$query = "SELECT city,site_name, site_url, site_text, site_img, site_click, site_lang, bad_link
from uarailway where city='$whatcity' order by site_name";
$mysee="Просмотр сайтов находящихся в городе ".$whatcity;
break;
case "categoria":
$query = "SELECT city,site_name, site_url, site_text, site_img, site_click, site_lang, bad_link
from uarailway where categoria='$whatcat' order by city";
$mysee="Просмотр сайтов по категории: ".$whatcat;
break;
case "request":
$query = "SELECT city,site_name, site_url, site_text, site_img, site_click, site_lang, bad_link
from uarailway where categoria='$whatcat' and city='$whatcity' order by site_name";
$mysee="Просмотр сайтов по категории ".$whatcat." в городе ".$whatcity;
break;
default:
{
$query = "SELECT city,site_name, site_url, site_text, site_img, site_click, site_lang, bad_link
from uarailway order by city";
$mysee="Весь список Украинских ж.д. сайтов";
}
}
?>
// =========Cycle of view===========
// query was define before
$res = mysql_query($query);
$numr=mysql_numrows($res);
echo "Найдено сайтов: ".$numr;
for($i=0; $i
";
if ($showtype=="cities")
{echo "".$name." "."URL: "."".$site_url." ".
" ".$language."";
if (mysql_result($res,$i,"bad_link")=="bad") {echo " Ссылка не работает.";}
echo "
".$opis;
}
if ($showtype=="categoria" or $showtype=="all" or $showtype=="" or $showtype=="request")
{echo "Город: ".$gorod." ".$name." "."URL: "."".$site_url." ".
" ".$language."";
if (mysql_result($res,$i,"bad_link")=="bad") {echo " Ссылка не работает.";}
echo "
".$opis;}
echo " | ";
$img=eregi_replace( "\"", "'", $name); // replace of qoutes "
echo "";
echo " |
|
|