[RESOLVED] another way around MYSQL errors

[msnhockey]

hey all,

i have this code and some more similiar
$team11 = mysql_result($result_schedules_scores1,$i,"team1");

and on some page I get a MYSQL error and most not. I know its from something empty, but is there something I can do to bypass or trick the database

here is the MYSQL error

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 43 in /home/cmhl/public_html/league/team.php on line 2301

[msnhockey]

i used this and it worked. so thanks

$result_schedules_scores1 = mysql_query("SELECT * FROM schedule_scores WHERE "

."(team1 = '$id' OR team2 = '$id') "
            ."AND season = '$sid' "
            ."AND team1_score = ' ' "
            ."AND team2_score = ' ' "
            ."ORDER BY date LIMIT 1");

$rcount3 = mysql_numrows($result_schedules_scores1);
if($rcount3 != 0) {

$team11 = mysql_result($result_schedules_scores1,$i,"team1"); 

} else {

  $team11 = ""; 	

}