 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
$link=mysql_connect("159.148.90.23","public","");
if($tau!="Nav svarīga")
{
$gfd=mysql_db_query("dzst","select tautiba from tautiba order by tautiba asc",$link);
while($rez=mysql_fetch_row($gfd))
{
$rezs=explode("-",$rez[0]);
if($rezs[2]){
$var=$rezs[0].$rezs[1].'/-'.$rezs[2];}
else {
$var=$rez[0];}
if($var==$tau){$rid=$rez[0];}
}
$que=" where tautiba = '".$rid."'";
}
if($tic!="Nav svarīga")
{
$gfd=mysql_db_query("dzst","select ticiba from ticiba order by ticiba asc",$link);
while($rez=mysql_fetch_row($gfd))
{
$rezs=explode("-",$rez[0]);
if($rezs[2]){
$var=$rezs[0].$rezs[1].'/-'.$rezs[2];}
else {
$var=$rez[0];}
if($var==$tic){$rid=$rez[0];}
}
if($que!="")
{$que=$que." and ticiba = '".$rid."'";}
else
{$que=" where ticiba = '".$rid."'";}
}
if($dzv!="Nav svarīga")
{if($que!="")
{$que=$que." and dzimsanas_vieta_valsts = '".$dzv."'";}
else
{$que=" where dzimsanas_vieta_valsts = '".$dzv."'";}
}
if($dzi!="Nav svarīgs")
{if($que!="")
{$que=$que." and dzimums = '".$dzi."'";}
else
{$que=" where dzimums = '".$dzi."'";}
}
if($dzga!="")
{if($que!="")
{$que=$que." and dzimsanas_gads >= ".$dzga."";}
else
{$que=" where dzimsanas_gads >= ".$dzga."";}
}
if($dzgb!="")
{if($que!="")
{$que=$que." and dzimsanas_gads <= ".$dzgb."";}
else
{$que=" where dzimsanas_gads <= ".$dzgb."";}
}
if($nod!="Nav svarīga")
{
$gfd=mysql_db_query("dzst","select nodarbosanas,id from nodarbosanas order by nodarbosanas asc",$link);
while($rez=mysql_fetch_row($gfd))
{
$rezs=explode("-",$rez[0]);
if($rezs[2]){
$var=$rezs[0].$rezs[1].'/-'.$rezs[2];}
else {
$var=$rez[0];}
if($var==$nod){$rid=$rez[1];}
}
if($que!="")
{$que=$que." and (nodarbosanas like '%-".$rid."' or nodarbosanas like '%-".$rid."-%' or nodarbosanas like '".$rid."-%' or nodarbosanas like '".$rid."')";}
else
{$que=" where (nodarbosanas like '%-".$rid."' or nodarbosanas like '%-".$rid."-%' or nodarbosanas like '".$rid."-%' or nodarbosanas like '".$rid."')";}
}
if($ipp!="Nav svarīga")
{
$gfd=mysql_db_query("dzst","select pieredze,id from pieredze order by pieredze asc",$link);
while($rez=mysql_fetch_row($gfd))
{
$rezs=explode("-",$rez[0]);
if($rezs[2]){
$var=$rezs[0].$rezs[1].'/-'.$rezs[2];}
else {
$var=$rez[0];}
if(str_replace('"','\\"',$var)==$ipp){$rid=$rez[1];}
}
if($que!="")
{$que=$que." and (pieredze like '%-".$rid."' or pieredze like '%-".$rid."-%' or pieredze like '".$rid."-%' or pieredze like '".$rid."')";}
else
{$que=" where (pieredze like '%-".$rid."' or pieredze like '%-".$rid."-%' or pieredze like '".$rid."-%' or pieredze like '".$rid."')";}
}
$gfd=mysql_db_query("dzst","select nr,indekss,indekss2,dzimums,tautiba from main".$que." order by nr asc;",$link);
if(mysql_num_rows($gfd)){
echo('
NR |
Indekss |
Dzimums |
Tautība |
');
$cnt=0;
while($rez=mysql_fetch_row($gfd)) {$cnt++;
echo('
'); echo(''.$rez[0].' | ');if(($rez[1]!=$rez[2])&&($rez[2])){echo($rez[1].', '.$rez[2].' | ');} else {echo($rez[1].' | ');}
echo($rez[3].' | ');
$dzim=explode("-",$rez[4]);if($rez[3]=="sieviete"){echo($dzim[0].$dzim[2]);} else {echo($dzim[0].$dzim[1]);}
echo(' |
');
}
echo(' ');} else
{ echo(' NEKAS NAV ATRASTS ');}
mysql_close($link);
?>
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
if($cnt>15) {$hgt=($cnt-15)*21;} else {$hgt=10;}
echo(' | ');
?>
|