[Resolved] something wrong ?

[DeadFly]

Anyone see anything wrong with this ?
My problem is that it won display the first record in the database.

$query="SELECT id, name, pos, CONCAT((goal*$PTS_Goal)+";
$query.="(assist*$PTS_Assist)+(otgoal*$PTS_OTGoal)+(shutout*$PTS_ShutOut)+";
$query.="(otwin*$PTS_OTWin)+(otloss*$PTS_OTLoss)) AS points "; 
$query.="FROM $TBL_Pla WHERE team=$team AND id > 0 ORDER BY name ASC";
$result=@mysql_query($query); ///// Run the query
$row=mysql_fetch_array($result, MYSQL_NUM); ///// Return a record if exists

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
	$clr = ($clr == '#FFFFFF'?$clr='#EEEEEE':$clr='#FFFFFF');
	echo '<tr bgcolor="'.$clr.'"><td align="left"><a href="'.intlink("view_player","plid=$row[0]").'">'.stripslashes($row[1]).'</a><font id="smtext">('.$row[2].')</font></td><td align="right">'.$row[3].' pts</td></tr>';
}
mysql_free_result ($result); ///// Free up the resources.

[laserlight]

Look at your "Return a record if exists" comment.

Arent you calling mysql_fetch_array() for the first row, before you loop through the other rows?

[DeadFly]

OMG.
I think I need to step away from the computer for a bit.

Thank you.