SQL query in php, professional help please?

A

Acrobot

New member
So basically, I want the variable $contest below to equal the total entries retured for Contest in the sql query array.


$sSQL = "SELECT *, (SELECT username FROM tableMembers WHERE memberId=tableContestComments.memberId) AS Member, (SELECT trackId FROM tableTracks WHERE memberId=tableContestComments.memberId AND title='track contest 1') AS Contest FROM tableContestComments ORDER BY commentsId DESC LIMIT $iStart, $iPageSize";

$objDb->query($sSQL);
$iCount = $objDb->getCount( );

for ($i = 0; $i < $iCount; $i ++)

{
$sComments = $objDb->getField($i, "comments");
$sSubmitted = $objDb->getField($i, "submitted");
$sMember = $objDb->getField($i, "Member");
$contest = $objDb->getCount($i, "Contest");
}

Any help is GREATLY appreciated,
thanks
 
Back
Top