自資料庫獲得單筆資料

自資料庫獲得單筆資料
//================================================================
$sql="select `b_team_sn`,`score`,`b_score`,`rank` from ".$xoopsDB->prefix("petanque_results")." where `game_sn` = '{$game_sn}' and `team_sn`='{$team_sn}' and `round` = '{$x}' ";
 $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, $sql);
 list($b_team_sn,$score,$b_score,$rank)=$xoopsDB->fetchRow($result);

//----------------------------------------------------------------------------------------
$xoopsDB->fetchRow($result)     =    mysql_fetch_row($result)