";
if(!mysql_select_db($dbname, $msql)) {$WasError=202; break; }
// echo "база выбрана
";
if(!isset($data_dob))$data_dob=4;
if(!isset($data_wedding))$data_wedding=0;
if(!isset($type))$type=4;
$q="(check_st=1)";
if(@$selectbook){
if($data_dob==1){$q.='&&((DATE_ADD(st_date, INTERVAL 30 day))>curdate())';}
elseif($data_dob==2){$q.='&&((DATE_ADD(st_date, INTERVAL 90 day))>curdate())';}
elseif($data_dob==3){$q.='&&((DATE_ADD(st_date, INTERVAL 360 day))>curdate())';}
//else{$data_dob=4;
// $first_vhod=$first_vhod-1;}
if($type==1){$q.='&&(((podgotovka_txt!="")||(svadba_txt!=""))&&(link!=""))';}
elseif($type==2){$q.='&&(link!="")';}
elseif($type==3){$q.='&&(((podgotovka_txt!="")||(svadba_txt!="")))';}
//else{$type=4;
//$first_vhod=$first_vhod-1;}
if($data_wedding==1995){$q.="&&(wed_year=1995)";}
elseif($data_wedding==1999){$q.="&&(wed_year=1999)";}
elseif($data_wedding==2000){$q.="&&(wed_year=2000)";}
elseif($data_wedding==2001){$q.="&&(wed_year=2001)";}
elseif($data_wedding==2002){$q.="&&(wed_year=2002)";}
elseif($data_wedding==2003){$q.="&&(wed_year=2003)";}
elseif($data_wedding==2004){$q.="&&(wed_year=2004)";}
elseif(($data_wedding<13)&&($data_wedding!=0))
{$q.="&&(wed_year=2005)&&(wed_month=$data_wedding)";}
elseif(($data_wedding>12)&&($data_wedding<25))
{$q.="&&(wed_year=2006)&&(wed_month=$data_wedding-12)";}
//else{$data_wedding=0;
//$first_vhod=$first_vhod-1;}
//echo "
q: $q
";
$qstr1="select * from story where ($q) ORDER by wed_year desc, wed_month desc, wed_day desc";
}
else {$qstr1="select * from story where check_st=1 order by st_date DESC limit 10";}
//echo "
$qstr1
";
$res_st=mysql_db_query($dbname, $qstr1, $msql);
if(!$res_st){$WasError=204; break; }
$N=mysql_num_rows($res_st);
// найдены все рассказы о свадьбах
$WasError=0;
} while(0);
?>
|