$field='why';
$page7="current";
require("/usr/local/www/peoples.ru/req/utils_new.class");
$my=new class_utils;
$my->sql_connect();
$gotid=$my->check_search_string(trim($q));
$gotid=trim($q);
$txt=""; $i=0;
$out="
\n
\n\n\n";
$qSQL = "SELECT * FROM describe_ru_section ORDER BY RAND()";
$qQResult = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResult)):
$i++;
$sectionname=$qrow['name'];
$sectionnameengl=$qrow['nameengl'];
$txt2="";
$aSQL = "SELECT * FROM describe_ru WHERE field='$field' AND section='$sectionnameengl' ORDER BY RAND() LIMIT 3";
$aQResult = mysql_query($aSQL);
if (mysql_error()) { print(mysql_error()); }
while ($row = mysql_fetch_array($aQResult)):
$name=trim($row['name']) ;
$path=trim($row['path']) ;
$section=trim($row['section']) ;
$visitors=trim($row['visitors']) ;
// $description=nl2br(trim($row['description']));
// $description_small=substr($description,0,200);
$txt2.="$name";
endwhile;
$out.="\n";
$out.="\n";
// $out.=" \n";
$out.=" \n";
$out.=" \n";
$out.=" | \n";
if ($i==2) { $out.="\n
\n\n"; $i=0; }
endwhile;
$out.="\n
";
/*
$aSQL = "SELECT * FROM describe_ru WHERE name LIKE '%$gotid%' OR description LIKE '%$gotid%'";
$aQResult = mysql_query($aSQL);
if (mysql_error()) { print(mysql_error()); }
while ($row = mysql_fetch_array($aQResult)):
$i++;
$name=trim($row['name']) ;
$idnum=trim($row['id']) ;
$nameengl=trim($row['nameengl']);
$datepub=trim($row['datepub']);
$path=trim($row['path']) ;
$section=trim($row['section']) ;
$visitors=trim($row['visitors']) ;
$description=nl2br(trim($row['description']));
$description_small=substr($description,0,200);
$qSQL = "SELECT * FROM describe_ru_photo WHERE id_describe='$idnum' ORDER BY RAND() LIMIT 1";
$qQResult = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResult)):
$photoname=trim($qrow['photoname']) ;
$width=trim($qrow['width']) ;
if ($width>50) { $width=50; };
$firstpicture="http://www.describe.ru/images/$photoname";
endwhile;
$txt.="\n | \n";
$txt.="\n";
$txt.="\n";
$txt.=" $description_small\nдалее » \n | \n";
$txt.="$datepub | \n$visitors | \n
\n";
endwhile;
*/
$my->sql_close();
?>
Бредовые идеи
require_once('/usr/local/www/describe.ru/www/ssi/head-dynamic-catalog.shtml');
// if (empty($txt)==true) { echo "по данному запросу ничего не найдено"; };
echo $out;
?>
require_once('/usr/local/www/describe.ru/www/ssi/foot-dynamic-catalog.shtml');
?>