Ваш гороскоп на $dayclient.$monthclient.$yearclient";
if ($monthclient<10) { $monthclient="0".$monthclient;}
if ($dayclient<10) { $dayclient="0".$dayclient;}
if ((empty($dayclient)<>true) && (empty($monthclient)<>true) && (empty($yearclient)<>true) && (empty($nameclient)<>true)) {
// echo "$day $month $year $name
"; echo "\n";
$qSQL = "SELECT hs.path AS horoscope_sign_path,hn.path AS horoscope_name_path,h.horoscope_sign_id,h.start,h.end,h.year,hs.description,hn.title AS horoscope_name, hs.title AS horoscope_sign
FROM horoscope h
LEFT JOIN horoscope_sign hs ON h.horoscope_sign_id=hs.id
LEFT JOIN horoscope_name hn ON hs.horoscope_name_id=hn.id
WHERE h.year='$yearclient'";
$qQResults = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResults)):
$i++;
$horoscope_sign_id=trim($qrow['horoscope_sign_id']);
$horoscope_name=trim($qrow['horoscope_name']);
$horoscope_sign=$qrow['horoscope_sign'];
$horoscope_name_path=trim($qrow['horoscope_name_path']);
$horoscope_sign_path=$qrow['horoscope_sign_path'];
$description=$qrow['description'];
$name=$qrow['name'];
$year=$qrow['year'];
echo "
";
}
$seek="";
$ii=0;
$dSQL = "
SELECT p.Epigraph,p.Title,p.DateIn,p.KodPersons
FROM peoples_data_stat_histories_today p
WHERE p.DateIn LIKE '%$monthclient-$dayclient' GROUP BY KodPersons ORDER BY p.DateIn DESC";
// WHERE p.DateIn ='$yearclient-$monthclient-$dayclient' GROUP BY KodPersons";
$dQResult = mysql_query($dSQL);
if (mysql_error()) { print(mysql_error()); }
//echo $dSQL;
while ($row = mysql_fetch_array($dQResult)) {
if($ii==0) {
echo "$nameclient, в один день с вами родились:
\n"; echo "\n";
}
$ii++;
$KodPersons=stripslashes($row['KodPersons']);
$DateIn=stripslashes($row['DateIn']);
$rec++; $Out_news=""; $Out_photo="";
// $OKodPersons=$row['KodPersons'];
$whole_infos=$my->findpersoninfo($KodPersons);
$whole_info=explode("##", $whole_infos);
$russian_name=trim($whole_info[0]); $english_name=trim($whole_info[1]); $IAllUrlInSity=$whole_info[2]; $in_site_path=$whole_info[3]; $who_is=$whole_info[4];
$famous_for=$whole_info[5]; $DateIn=$whole_info[6]; $DateOut=$whole_info[7]; $TownIn=$whole_info[8]; $TownOut=$whole_info[9]; $KodCountry=$whole_info[10]; $wholenames=$whole_info[11];
$Oarticle=substr(stripslashes($row['Epigraph']), 0, 250)." ....";
$Otitle=stripslashes($row['Title']);
if (empty($Otitle)==true) {
$Otitle=$russian_name;
} else {
$Otitle=$Otitle."/".$russian_name;
}
$full_photo=$my->peoples_photo($KodPersons);
$img="";
if (empty($full_photo)<>true) {
$img="
"; }
}
} else {
echo "
"; echo "
\n";
echo "![](\"/horoscope/pic/$horoscope_name_path/$horoscope_sign_path.gif\") | ";
echo "$horoscope_name: $horoscope_sign | "; echo "$horoscope |
| \n";
echo " | ";
echo "$horoscope_name: $horoscope_sign | "; echo "$horoscope |
\n"; echo "
$Oarticle ($full_name [$Odate]) | ";
// $Out_photo="||
$Otitle".$my->date_rus($DateIn)." | ||
| $img | $Oarticle | \n".$Out_photo." |
| \n"; require_once('/usr/local/www/peoples.ru/www/ssi/ads-468x60.shtml'); echo " | ||
| \n"; require_once('/usr/local/www/peoples.ru/www/ssi/rec2.shtml'); echo " | ||
| \n"; require_once('/usr/local/www/peoples.ru/www/ssi/rec4.html'); echo " | ||
Ваш гороскоп
"; } ?>
$pages_count) $page = $pages_count;
$start_pos = ($page - 1) * $perpage; // Начальная позиция, для запроса к БД
// Вызов функции, для вывода ссылок на экран
echo "\n";
$my->universal_link_bar($page, $count, $pages_count, 9);
echo " \n";
// Вывод информации из базы данных
$rec=0;
*/
echo "\n";
$qSQL = "SELECT hs.path AS horoscope_sign_path,hn.path AS horoscope_name_path,h.horoscope_sign_id,h.start,h.end,h.year,hs.description,hn.title AS horoscope_name, hs.title AS horoscope_sign
FROM horoscope h
LEFT JOIN horoscope_sign hs ON h.horoscope_sign_id=hs.id
LEFT JOIN horoscope_name hn ON hs.horoscope_name_id=hn.id";
//echo $qSQL;
$qQResults = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResults)):
$i++;
$horoscope_sign_id=trim($qrow['horoscope_sign_id']);
$horoscope_name=trim($qrow['horoscope_name']);
$horoscope_sign=$qrow['horoscope_sign'];
$horoscope_name_path=trim($qrow['horoscope_name_path']);
$horoscope_sign_path=$qrow['horoscope_sign_path'];
$description=$qrow['description'];
$name=$qrow['name'];
$start=$qrow['start'];
$end=$qrow['end'];
$year=$qrow['year'];
if (empty($year)<>true) {
$type=1;
$horoscope=$year." год";
} else {
$type=2;
$dates=explode("-",$start);
$horoscope=$dates[2]." ".$my->numtomonth2($dates[1])." - ";
$dates=explode("-",$end);
$horoscope.=$dates[2]." ".$my->numtomonth2($dates[1]);
};
echo "
\n";
/*
// Вызов функции, для вывода ссылок на экран
echo "\n";
$my->universal_link_bar($page, $count, $pages_count, 9);
echo " \n";
*/
?>
| \n";
echo " | ";
echo "$horoscope_name: $horoscope_sign | "; echo "$horoscope |