$sql = "SELECT COUNT(*) FROM ".$db->prefix("friendsearch")." WHERE uid = ".$thisUser->uid()."";
$result = $db->query($sql);
list($ret) = $db->fetch_row($result);
if ($ret >= 1){
echo "Anzeige vorhanden";
}else{
echo "keine Anzeige vorhanden";
}

$sql = "SELECT COUNT(*) FROM ".$db->prefix("friendsearch")." WHERE uid = ".$thisUser->uid()."";

$result = $db->query($sql);

list($ret) = $db->fetch_row($result);
if ($ret >= 1){

echo "
<table border='0' cellpadding='6' cellspacing='1' width='100%'><tr valign='top' class='bg1'><br>
<td colspan='2' align='center'><b>Single-Börse Eintrag vorhanden</b></td></tr><tr valign='top' class='bg3'><td>";
echo "</table></td></tr>";

}else{
echo "
<table border='0' cellpadding='6' cellspacing='1' width='100%'><tr valign='top' class='bg1'><br>
<td colspan='2' align='center'><b>Noch nicht in die Single-Börse eingetragen</b></td></tr></table>";

if($xoopsUser){ //anfang
echo "
<table border='0' cellpadding='6' cellspacing='1' width='100%'><tr valign='top' class='bg3'><td>";
if ( $uid == $xoopsUser->getVar("uid") &amp;&amp; $ret == 0) {
echo "<center><b><a href='".XOOPS_URL."/modules/friendsearch/add.php' target='_self'>Sich eintragen in die Single-Börse eintragen?</a></b></center>";
}
echo "</table></td></tr>"; } //ende
}

echo $myts->makeTareaData4Show($thisUser->getVar("bio", "N"), 0, 1, 1);
echo "</td></tr>";
}
echo "</table></table><br>";