Chapel Help

[lee28]

can any u guys help when ppl get wappied it works but says the wronge thing on profiles as it ment b the lads are owned by the gals and the gals are the lads bitches but it showin other way round heres wot i got for on profiles



$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE who='".$who."'"));
if($couple[0]=='1')
{
echo "Wappid to:";
$unick = getnick_uid($couple[2]);
echo "$whonick is owned by: $unick
";
}
$couples = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE partner='".$who."'"));
if($couples[0]=='1')
{
echo "Wappid to:";
$nick = getnick_uid($couples[1]);
echo "$whonick is $nick's bitch
";
}
$noi = mysql_fetch_array(mysql_query("SELECT lastact FROM ibwf_users WHERE id='".$who."'"));
$var1 = date("His",$noi[0]);
$var2 = time();
$var21 = date("His",$var2);
$var3 = $var21 - $var1;
$var4 = date("s",$var3);
echo "Idle For: ";
$remain = time() - $noi[0];
$idle = gettimemsg($remain);
echo "$idle
"



any help to sort it would b great

[crazybrumi]

try this, iv just gone on the principle of changine the variable names around. so it might not work as i havent read all of it.

$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE who='".$who."'"));
if($couple[0]=='1')
{
echo "[b]Wappid to:[/b]";
$unick = getnick_uid($couple[2]);
echo "$unick is owned by: $whonick 
";
}
$couples = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE partner='".$who."'"));
if($couples[0]=='1')
{
echo "[b]Wappid to:[/b]";
$nick = getnick_uid($couples[1]);
echo "$nick's is $whonick  bitch 
";
}
$noi = mysql_fetch_array(mysql_query("SELECT lastact FROM ibwf_users WHERE id='".$who."'"));
$var1 = date("His",$noi[0]);
$var2 = time();
$var21 = date("His",$var2);
$var3 = $var21 - $var1;
$var4 = date("s",$var3);
echo "[b]Idle For:[/b] ";
$remain = time() - $noi[0];
$idle = gettimemsg($remain);
echo "$idle
";

[lee28]

cheers m8 that didnt work tho just made screen go white lol thanx anyway for tryin

[metulj]

<div class='quotetop'>QUOTE (lee28 @ Mar 7 2009, 09:18 AM) <{POST_SNAPBACK}></div>

cheers m8 that didnt work tho just made screen go white lol thanx anyway for tryin[/b]

theres missing <span style="font-size:12pt;line-height:100%">;</span>
after

echo "$idle
"

that surely not good..

[crazybrumi]

nicely pointed out metulj. try nw lee

[lee28]

same still white screen m8

[subzero]

$couple = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE who='".$who."'"));
if($couple[0]=="1")
{
echo "[b]Wappid to:[/b]";
$unick = getnick_uid($couple[2]);
echo "$unick is owned by: $whonick 
";
}
$couples = mysql_fetch_array(mysql_query("SELECT accept, who, partner FROM couple WHERE partner='".$who."'"));
if($couples[0]=="1")
{
echo "[b]Wappid to:[/b]";
$nick = getnick_uid($couples[1]);
echo "$nick's is $whonick  bitch 
";
}
$noi = mysql_fetch_array(mysql_query("SELECT lastact FROM ibwf_users WHERE id='".$who."'"));
$var1 = date("His",$noi[0]);
$var2 = time();
$var21 = date("His",$var2);
$var3 = $var21 - $var1;
$var4 = date("s",$var3);
echo "[b]Idle For:[/b] ";
$remain = time() - $noi[0];
$idle = gettimemsg($remain);
echo "$idle
";

when having " to &#39; page it will not show so place "