Jan: HTTP_COOKIE_VARS

Beitrag lesen

Hi,

mysql_fetch_array(mysql_query("SELECT * FROM user WHERE    sessid='" .session_id(). "'"));

das ist ja nur einleuchtend - wahrscheinlich pruefst Du nicht einmal, ob session_id() einen wert hat!

Welchen Wert soll session_id denn haben?

das mit dem Quellcode posten macht denke ich durchaus sehr viel sinn! das haettest du auch frueher vorschlagen koennen.

$qid = mysql_query("SELECT * FROM user WHERE sessid='".session_id()."'");
while($data = mysql_fetch_array($qid)) {
 $sdata = mysql_fetch_array(mysql_query("SELECT * FROM user_details WHERE uid='$data[0]'"));
?>
<table border="1" boder-color="#000000" bgcolor="#DEDEDE" cellspacing="0" cellpadding="0" width="540">
<tr>
 <td align="center"><font size="1"><a href="./updateprofileform.php?uid=<? echo ?>">Profil bearbeiten</a></td>
 <td align="center">PN´s</td>
 <td align="center">Gästebuch</td>
 <td align="center">Friends suchen</font></td>
</tr>
</table>
<br>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
  <td width="350">
<table border="0" cellspacing="6" cellpadding="0" valign="top" align="left">
<tr>
  <td width="150"><b>Username:</b></td>
  <td><? echo $data[1]; ?></td>
 <tr>
  <td width="150"><b>Name:</b></td>
  <td><? echo $data[4]; ?> <? echo $data[3]; ?></td>
<tr>
  <td width="150"><b>Wohnort:</b></td>
  <td><p><? echo $sdata[7]; ?></td>
<tr>
  <td width="150"><b>Alter:</b>
  <td>
<?
    $alter = date("Y")-$sdata[6];
    if(($monat[5] > date("m")) || ($monat[5] == date("m") && $tag[4] < date("d"))) {
    $alter--;
    }
    echo $alter; ?> Jahre
  </td>
<tr>
  <td width="150"><b>ICQ:</b>
  <td><img src="http://status.icq.com/online.gif?web=<? echo $sdata[3];?>&img=5"> <? echo $sdata[3]; ?> </td>
<tr>
  <td width="150"><b>E-Mail:</b></td>
  <td>
<?
if(mysql_num_rows(mysql_query("SELECT showemail FROM user_details WHERE uid='$data[0]' AND showemail='Y'")))  {
 echo "<a href="mailto: $data[5];">$data[5]</a>"; }
else  {
  echo "keine Angabe";
}
?></td>
<tr>
</tr>
</table>
</td>
  <td valign="top" align="right">

<img style="border-color:#000000" src="./userimg.php?uid=<? echo $data[0]; ?> width="180" height="135" border="2" alt=<? echo $data[1]; ?>></a>

</td>
</tr>
</table>
<?
$idata = mysql_fetch_array(mysql_query("SELECT * FROM user_interessen WHERE uid='$data[0]'"));
?>
<table border="0" cellspacing="6" cellpadding="0"
<tr>
  <td width="150"><b>Interessen:</b>
  <td><input type="radio" <? if($idata[1] == "Y") echo "checked"; ?>>&nbsp;Fernsehen</td>
  <td><input type="radio" <? if($idata[2] == "Y") echo "checked"; ?>>&nbsp;Kino</td>
  <td><input type="radio" <? if($idata[3] == "Y") echo "checked"; ?>>&nbsp;Freunde treffen</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($idata[4] == "Y") echo "checked"; ?>>&nbsp;Flirten</td>
  <td><input type="radio" <? if($idata[5] == "Y") echo "checked"; ?>>&nbsp;Computer</td>
  <td><input type="radio" <? if($idata[6] == "Y") echo "checked"; ?>>&nbsp;Disco/Partys</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($idata[7] == "Y") echo "checked"; ?>>&nbsp;Sport</td>
  <td><input type="radio" <? if($idata[8] == "Y") echo "checked"; ?>>&nbsp;Musik</td>
  <td><input type="radio" <? if($idata[9] == "Y") echo "checked"; ?>>&nbsp;Musik machen</td>
 <tr>
  <td>&nbsp;</td>
  <td colspan="3">&nbsp;</td>
</tr>
<?
$mdata = mysql_fetch_array(mysql_query("SELECT * FROM user_musik WHERE uid='$data[0]'"));
?>
 <tr>
  <td width="150"><b>Musik:</b></td>
  <td><input type="radio" <? if($mdata[1] == "Y") echo "checked"; ?>>&nbsp;R'n'B</td>
  <td><input type="radio" <? if($mdata[2] == "Y") echo "checked"; ?>>&nbsp;Pop/Charts</td>
  <td><input type="radio" <? if($mdata[3] == "Y") echo "checked"; ?>>&nbsp;Techno/House</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($mdata[4] == "Y") echo "checked"; ?>>&nbsp;HipHop</td>
  <td><input type="radio" <? if($mdata[5] == "Y") echo "checked"; ?>>&nbsp;80's</td>
  <td><input type="radio" <? if($mdata[6] == "Y") echo "checked"; ?>>&nbsp;Raggae</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($mdata[7] == "Y") echo "checked"; ?>>&nbsp;Heavy Metall</td>
  <td><input type="radio" <? if($mdata[8] == "Y") echo "checked"; ?>>&nbsp;Klassik/Oper</td>
  <td><input type="radio" <? if($mdata[9] == "Y") echo "checked"; ?>>&nbsp;Rock</td>
 <tr>
  <td>&nbsp;</td>
  <td colspan="3">&nbsp;</td>
 </tr>
<?
$edata = mysql_fetch_array(mysql_query("SELECT * FROM user_essen WHERE uid='$data[0]'"));
?>
 <tr>
  <td width="150"><b>Bevorzugtes Essen:</b></td>
  <td><input type="radio" <? if($edata[1] == "Y") echo "checked"; ?>>&nbsp;Fast Food</td>
  <td><input type="radio" <? if($edata[2] == "Y") echo "checked"; ?>>&nbsp;Vegetarisch</td>
  <td><input type="radio" <? if($edata[3] == "Y") echo "checked"; ?>>&nbsp;Türkisch</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($edata[4] == "Y") echo "checked"; ?>>&nbsp;Deutsch</td>
  <td><input type="radio" <? if($edata[5] == "Y") echo "checked"; ?>>&nbsp;Griechisch</td>
  <td><input type="radio" <? if($edata[6] == "Y") echo "checked"; ?>>&nbsp;Italienisch</td>
 <tr>
  <td>&nbsp;</td>
  <td><input type="radio" <? if($edata[7] == "Y") echo "checked"; ?>>&nbsp;Chinesisch</td>
  <td><input type="radio" <? if($edata[8] == "Y") echo "checked"; ?>>&nbsp;Französisch</td>
  <td><input type="radio" <? if($edata[9] == "Y") echo "checked"; ?>>&nbsp;Sonstiges</td>
 <tr>
  <td colspan="4">&nbsp;</td>
 <tr>
  <td width="150"><b>Flirtstatus:</b>
  <td><input type="radio" <? if($sdata[8] == "v") echo "checked"; ?>>&nbsp;Vergeben!</td>
  <td><input type="radio" <? if($sdata[8] == "s") echo "checked"; ?>>&nbsp;Single</td>
  <td><input type="radio" <? if($sdata[8] == "h") echo "checked"; ?>>&nbsp;Verheiratet!</td>
</tr>
</table>

ich bitte darum ;)

Den Gefallen werde ich dir tun!;)

Gruß Jan