db fetch array drupal 7

Question

I've an issue with a migration from a drupal 6 to 7 website. I'm a beginner in PHP and MySQL and I can't find a solution to my problem.

The code I'm struggling with is following:

$sql = "select ID_Speler from TB_Spelers where uid = ".$id;
$row = db_fetch_array(db_query($sql));
$speler = $row['ID_Speler'];

I always get a "Call to undefined function db_fetch_array()"

Any help is very much appreciated.

Answer 1

Try like that:

 $sql = "select ID_Speler from TB_Spelers where uid = %d";
 $query = db_query($sql, $id);
 while ($records = db_fetch_array($query)) {
   $spelers[] = $records['ID_Speler'];
 }
 print_r($spelers);