ciberjoerg
Erfahrenes Mitglied
Ich bekomm bei meinem script ne "Query was empty" meldung. ich weis allerdings nicht Woran das liegen kann.
PHP:
<script type="text/javascript" src="temps/wz_tooltip.js"></script>
<? //newuser2.0
$nusr = mysql_connect($conf_pass->db_host,$conf_pass->db_user,$conf_pass->db_pass) or die ("Keine Verbindung moeglich");
mysql_select_db("$conf_pass->db_name") or die ("Die Datenbank existiert nicht");
$abnusr = "SELECT
li.nic AS usr_nic,
li.user_id AS usr_id,
uon.last_act AS activ,
da.sex AS sex,
da.agestamp AS age,
da.hobbies AS hobbie,
da.love AS lovelife,
da.Vorname AS Vname,
cty.Ort AS Ort
FROM
fa_pass0_login AS li
JOIN u_on AS uon ON uon.user_id = li.user_id
JOIN fa_pass0_data AS da ON da.user_id = li.user_id
JOIN orte AS cty ON cty.PLZ = da.plz
ORDER BY
li.user_id
DESC LIMIT
10
";
$ergusr = mysql_query($abusr)or die(mysql_error());
$menge = mysql_num_rows($ergusr);
$ux=0;
//echo $menge." Freunde Online<br>";
while($rusr = mysql_fetch_object($ergusr))
{
$usr_nic= $rusr->usr_nic;
$usr_id= $rusr->usr_id;
$Vname= $rusr->Vname;
$age = $rusr->age;
$sex = $rusr->sex;
$activ = $rusr->activ;
$hobby = $rusr->hobbie;
$love = $rusr->lovelife;
$ort = $rusr->Ort;
if($sex == M){
$sexz="<img src=\'images/maennlich.png\' width=\'10\' height=\'10\'> ";
}
if($sex == W){
$sexz="<img src=\'images/weiblich.png\' width=\'10\' height=\'10\'> ";
}
if (file_exists('Upics/'.$usr_nic.'/'.$usr_nic.'.jpg')) {
$usr_pic= "Upics/".$usr_nic."/".$usr_nic.".jpg";
}
else{
if($sex == M){
$usr_pic= "images/member_big_m.jpg";
}
if($sex == W){
$usr_pic= "images/member_big_w.jpg";
}
}
$age2 = time() - $age;
$age1 = date("Y", $age2) - date("Y", strtotime("1970-01-01"));
?>
<a onmouseover="Tip('<DIV CLASS=\'popup\'><img src=\'thumb.php?size=80&img=<?=$usr_pic?>\' width=\'90\' border=\'0\' CLASS=\'box\' /><?=$sexn?><STRONG><?=$usr_nic?></STRONG> » Status: <SPAN CLASS=\'offline\'>offline</SPAN><BR><?=$vname?> aus <?=$ort?> (<?=$age1?>)<BR>Lovelife: <?=$love?><BR>Hobbies : meine hobbies</DIV>')" onmouseout="UnTip()" href=""><img src="thumb.php?size=50&img=<?=$usr_pic?>" border="0" /></a>
<?
}
?>
