echo '<a href="'.$trans_name_razdel.'-'.$id_razdel.'">'.$name_razdel.'</a><br />';

 

 

function translite ($st)

 

 

 

 

    $st =strtr($st,

       

        array(

        "А"=>"A","Б"=>"B","В"=>"V","Г"=>"G",

        "Д"=>"D","Е"=>"E","Ж"=>"J","З"=>"Z","И"=>"I",

        "Й"=>"Y","К"=>"K","Л"=>"L","М"=>"M","Н"=>"N",

        "О"=>"O","П"=>"P","Р"=>"R","С"=>"S","Т"=>"T",

        "У"=>"U","Ф"=>"F","Х"=>"H","Ц"=>"TS","Ч"=>"CH",

        "Ш"=>"SH","Щ"=>"SCH","Ъ"=>"","Ы"=>"YI","Ь"=>"",

        "Э"=>"E","Ю"=>"YU","Я"=>"YA","а"=>"a","б"=>"b",

        "в"=>"v","г"=>"g","д"=>"d","е"=>"e","ж"=>"j",

        "з"=>"z","и"=>"i","й"=>"y","к"=>"k","л"=>"l",

        "м"=>"m","н"=>"n","о"=>"o","п"=>"p","р"=>"r",

        "с"=>"s","т"=>"t","у"=>"u","ф"=>"f","х"=>"h",

        "ц"=>"ts","ч"=>"ch","ш"=>"sh","щ"=>"sch","ъ"=>"y",

        "ы"=>"yi","ь"=>"","э"=>"e","ю"=>"yu","я"=>"ya"

               

                )

    );

 

            $st =preg_replace('((\W+))', ' ', $st);

                        $st =str_replace('_', ' ', $st);

                        $st =trim($st);

                        $st =preg_replace('((\s+))', '-', $st);

                        $st =strtolower($st);

                        return $st;

 

 

 

$query = "SELECT SQL_CACHE t1.id_profecy, t1.id_parent, t1.name_profecy, t1.sort, t2.id_razdel, t2.name_razdel, t2.sort FROM profecy t1

                   

                   $result = mysql_query($query);

                   

                   while($line_cat = mysql_fetch_assoc($result))

$id_razdel = $line_cat['id_razdel'];

$name_razdel = $line_cat['name_razdel'];

$id_parent = $line_cat['id_parent'];

$name_subcat = $line_cat['name_profecy'];

 

 

 

 

while ($line = mysql_fetch_assoc($result))

        {

 

 

 //в теле цикла выводится div с данными

echo '<div class="'.$class.'">********</div>';

 

 

 

 

$query = "SELECT  * FROM street";

$items = mysql_query($query);

                                         

               while ($item = mysql_fetch_assoc($items))

                 {                             

              echo '<div onclick="in_fStreetAdd(this)" value="'.$item['name_street'].'" >'.$item['name_street'].'</div>';

                         

                            }

                                                                                                                                                                                                                                 

               while ($item = mysql_fetch_assoc($items))

                 {                             

       echo '<div style="display: none;" onclick="in_fStreetDel(this)" value="'.$item['name_street'].'" ><span style="color: red;">'.$item['name_street'].'</span></div>';

                            }

                               

 

 

 

$query = "SELECT SQL_CACHE SQL_CALC_FOUND_ROWS * FROM tablename1 WHERE active="1" AND id_razdel="id_razdel""

                   . " AND id_rubpkv="id_rubpkv" AND id_oblast="id_oblast" AND id_city="id_city" AND $zp_sort>='$zp'"

                   . " AND currency="id_currency"  LIMIT $offset, $perPageSearch";

        $result = mysql_query($query);

        $line = mysql_fetch_assoc($result);

 

 

$query_c = "SELECT SQL_CACHE city.id_city, city.name_city, obl.id_oblast, obl.name_oblast FROM city AS city, oblast AS obl WHERE city.id_city='$line[id_city]' AND obl.id_oblast='$line[id_oblast]'";//$line[id_oblast]' береться из первого запроса

                $result_c = mysql_query($query_c);

            $line_c = mysql_fetch_assoc($result_c);

 

 

$query = "SELECT SQL_CACHE SQL_CALC_FOUND_ROWS * FROM $search_table WHERE $moder AND id_razdel$razdel"

                   . " AND id_rubpkv$prof AND id_oblast$oblast AND id_city$city AND $zp_sort>='$zp'"

                   . " AND currency_$type$currency AND (info_$type $q '$info_search') $order LIMIT $offset, $perPageSearch";

        $result = mysql_query($query);

        $line = mysql_fetch_assoc($result);

 

 

$query_c = "SELECT SQL_CACHE city.id_city, city.name_city, obl.id_oblast, obl.name_oblast FROM $city_t AS city, $oblast_t AS obl WHERE city.id_city='$line[id_city]' AND obl.id_oblast='$line[id_oblast]'";

                $result_c = mysql_query($query_c);

            $line_c = mysql_fetch_assoc($result_c);

 

 

    if(in_array($_SESSION['test'][],$row_Recordset1['id'])){ echo 'пассив'; } else { echo 'актив';}

 

 

if(in_array($row_Recordset1['id'], $_SESSION['test'])) { echo 'пассив'; } else { echo 'актив';}