get_records_sql in Moodle 2.0

get_records_sql in Moodle 2.0

by Mike Shurance -
Number of replies: 2

I have a module I wrote in 1.9 that calls the get_records_sql(). However, this function does not seem to work in 2.0

Any help would be great!

Here is my code:

  $sql = "MY SQL STRING";
  $records = get_records_sql($sql);
        foreach ($records as $id => $record) {

Average of ratings: -
In reply to Mike Shurance

Re: get_records_sql in Moodle 2.0

by Mike Shurance -

Fixed it!

I changed
      $records = get_records_sql($sql);
to
      $records = $DB->get_records_sql($sql);

Can someone confrim that in Moodle 2.0 $DB-> is in fact required.

Thanks!

Average of ratings: -