PHP Issue

[karimali831]

Hi members,

Is there anything wrong with the below code

    //GET TEAM INVITATIONS
    $query = "SELECT teamid,playerid,inviterid,DATE_FORMAT(invitedate, '%M %d, %Y') FROM teammembersinv WHERE playerid='$plyr[id]' ORDER by invitedate";
    // $invitations = resource id
    $invitations = mysql_query($query);
    while(list($team,$playerid,$inviterid,$invitedate)=mysql_fetch_row($invitations)){
        $teaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$team'");
        $tinfo=mysql_fetch_array($teaminfo);
        $inviterinfo=mysql_query("SELECT alias FROM users WHERE id='$inviterid'");
        $inviter=mysql_fetch_array($inviterinfo);
        $status=member_status($status);
        $invites=$invites."$out[bulletcenter] » Invitation by <a href='$url[base]/$file[teams]?teamid=$team'>$tinfo[teamname]</a><br>"; //outputs the result
    }
    if(!$invites){
        $invites = "$out[bulletcenter] » 0 Invitations"; 
    }

Thanks

[black-dog]

Well I'm guessing that, as you posted it, yes there is something wrong with it. I assume you are getting no output and that's because there is no echo or print in there (though this could come later). There are variables and arrays that are not defined and arrays that are defined and not used but I assume that this is not the whole code. Also I would have though you could have achieved this by using a join - but without knowing if your db is properly normalised I can't really say.

Your question is rather too vague. What did you expect it to do?

[karimali831]

oo sorry, I'm still learning. I'll try and be more specific