$pagetitle = "Search Results"; $pageheadline = $pagetitle; include "../e136header.phtml"; include "../e136funcs.php"; include "../include/siteaccess.phtml"; $now = time(); mysql_connect("localhost","wwwpublic",""); mysql_select_db("e136"); if (strlen($s)): /* $s = msql_regcase($s); */ $rule = " where ( vorname like '%$s%' or nachname like '%$s%' or org like '%$s%' or vortit like '%$s%' or leiter like '%$s%' ) "; endif; if ($g==2): $rule = addAnd($rule, "gastvor=1"); endif; if ($g==3): $rule = addAnd($rule, "gastauf=1"); endif; if ($t==""): $t=0; endif; if ($t==1): $vonzeit = timeunix($tag,$monat,$jahr); $biszeit = timeunix($day,$month,$year); endif; $o = "nachname"; $result = mysql_query("select * from stammgast $rule order by $o"); $nhit = mysql_num_rows($result); ?> if ($t==1): ?>
endif?>
$i=0;
while ($i<$nhit):
$id = mysql_result($result,$i,"id");
if ($t==1):
$true=0;
$subresult=mysql_query("select id,von,bis from gastzeit where id=$id");
$num=mysql_num_rows($subresult);
$j=0;
while ($j<$num):
$von = mysql_result($subresult,$j,"von");
$bis = mysql_result($subresult,$j,"bis");
if ($von<$vonzeit && $bis>$vonzeit): $true=1; endif;
if ($von<$biszeit && $bis>$biszeit): $true=1; endif;
if ($von>=$vonzeit && $bis<=$biszeit): $true=1; endif;
$j++;
endwhile;
else:
$true=1;
endif;
if ($true==1): ?>
if ($siteaccess): ?>
&db=stammgast">
endif?>
echo mysql_result($result,$i,"vorname")?>
echo mysql_result($result,$i,"nachname")?>
if ($siteaccess): echo""; endif?>
( echo mysql_result($result,$i,"leiter")?>)
echo mysql_result($result,$i,"org")?>
echo mysql_result($result,$i,"ort")?>,
echo mysql_result($result,$i,"land")?>.
if (mysql_result($result,$i,"gastauf")==1):
$subresult=mysql_query("select * from gastzeit where id=$id and type='A'")?>
echo mysql_result($subresult,0,"v_tag")?>. echo mysql_result($subresult,0,"v_monat")?>. echo mysql_result($subresult,0,"v_jahr")?> bis
echo mysql_result($subresult,0,"b_tag")?>. echo mysql_result($subresult,0,"b_monat")?>. echo mysql_result($subresult,0,"b_jahr")?>
endif;
if (mysql_result($result,$i,"gastvor")==1):
$subresult=mysql_query("select * from gastzeit where id=$id and type='V'")?>
Vortrag:
echo mysql_result($result,$i,"vortit")?> am
echo mysql_result($subresult,0,"v_tag")?>. echo mysql_result($subresult,0,"v_monat")?>. echo mysql_result($subresult,0,"v_jahr")?>
endif;
endif;
echo "
"; $i++; endwhile; include "../e136footer.phtml"; exit?>