$oLangPack=setLangpack("",$defaultlanguage);?>
Gesuche
>
$ocon = new mysqlconnection;
$ocon->open($host,$dbname,$user,$passwd);
$strSQL = "select count(*) from $table_interessenten";
$count = $ocon->getvalue($strSQL);
echo "
\n";
echo " ". $oLangPack->translatestring("Unsere Kundenliste beinhaltet derzeit %1 Interessenten",array("$count")).". ". $oLangPack->translatestring("Stand").": " .Date("d.m.Y")."\n";
echo "
";
if ( $cmdSENT == $oLangPack->translatestring("Suche starten")."...")
{
$strSQLWhere = "where (1=1)";
if ($TXT_GESUCHART != "" and $TXT_GESUCHART != "kauf_miete")
$strSQLWhere .= " and (INT_ART like '%$TXT_GESUCHART%')";
if ( $TXT_PLZ != "" )
$strSQLWhere .= " and (INT_PLZ like '$TXT_PLZ%')";
if ( $TXT_ORT != "" )
$strSQLWhere .= " and (INT_ORT like '$TXT_ORT%')";
if ($strSQLWhere=="where (1=1)")
$strSQLWhere = "";
$strSQL = "select ".$oLangPack->GetColumnName("INT_HEADLINE").",".$oLangPack->GetColumnName("INT_DETAILS")." from $table_interessenten ".$strSQLWhere;
$rs = $ocon->openrecordset($strSQL);
if ( $rs->recordcount == 0 )
{
$title = $oLangPack->translatestring("Gesuche");
$msg = "
" .$oLangPack->translatestring("Es wurden keine Gesuche gefunden")."
";
ffws_MsgBox($title, $msg);
}
else
{
while ( !$rs->eof )
{
list($INT_HEADLINE, $INT_DETAILS) = $rs->fields;
ffws_MsgBox($INT_HEADLINE, $INT_DETAILS, "middle");
$rs->movenext();
} // while
}
$rs->close();
$ocon->close();
}
?>