viewuser married info

[honkytonkman]

i put with some problems the chapel function in my italian wapdesire xhtml version, i think
it's workin'right now..
but i would need a code to put on index.php ,on viewuser action,
saying, for exemple,:
questo utente fa COPPIA PEOPLEIANA con:
(this user is married with)

i tried to do by myself this but not works right..

//////////couple adv.


$we = mysql_fetch_array(mysql_query("SELECT who, partner, accept, req FROM couple WHERE who='".$uid."'"));
if($we[2]=='1')
{
$wer = getnick_uid($we[1]);


      echo "<br/><img src=\"../images/Heart.gif\" alt=\"\"/><br/>";

echo "questo utente fa COPPIA PEOPLEIANA con: $wer!<br/>";
}

//////end

i do a disaster code ehm..

[honkytonkman]

i found this on lava ,but it's a buggy code for a fool grammatical wrong..
couples instead couple

$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE who='".$who."'"));
if($couple[0]=='1')
{
echo "<b>RELATIONSHIP</b><br/>";
$unick = getnick_uid($couple[2]);
echo "$whonick is partnered by $unick <br/>";
}
$couples = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE partner='".$who."'"));
if($couples[0]=='1')
{
echo "<b>RELATIONSHIP</b><br/>";
$nick = getnick_uid($couples[1]);
echo "$whonick is partnered by $nick <br/>";
}

this is the right code..

$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE who='".$who."'"));
if($couple[0]=='1')
{
echo "<b>RELATIONSHIP</b><br/>";
$unick = getnick_uid($couple[2]);
echo "$whonick is partnered by $unick <br/>";
}
$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE partner='".$who."'"));
if($couple[0]=='1')
{
echo "<b>RELATIONSHIP</b><br/>";
$nick = getnick_uid($couple[1]);
echo "$whonick is partnered by $nick <br/>";
}