Drupal - db_fetch_array returns NULL for every row

Posted by darudude on Stack Overflow See other posts from Stack Overflow or by darudude
Published on 2010-05-11T14:25:06Z Indexed on 2010/05/13 7:04 UTC
Read the original article Hit count: 141

Filed under:
|
|
|

I'm using Drupal's db_fetch_array to fetch rows from my db_query. However, every row returned is equal to NULL. Typing the query into PHP myadmin works, so I have no idea whats going on. db_num_rows returns the number of rows as well. Here is the code:

if(count($rebuild_ids))
  {
    $ids=implode(",",$rebuild_ids);
    $type_stmt = "SELECT * from {" . ItemType::$type_table_name . "} where id IN ($ids)";
    $new_items=db_query($type_stmt);
    if(!$new_items || db_num_rows($new_items) == 0)
    {
        return;
    }
    while($row = db_fetch_array($new_items));
    {
      if ($row!=NULL)
      {
          echo "I work!"
          $game_items[] = $row['id'];
          ItemInstance::$nid_to_item_type_code[$row['nid']] = $row['id'];
      }
    }
  }

However, it never gets into the third if statement (i.e. never echos "I work!") Any ideas?

© Stack Overflow or respective owner

Related posts about drupal

Related posts about php