How to output records in HTML table from moodle database?

I want to display data from moodle database in HTML table, but for every record separate table is being displayed: Code: $rec=$DB->get_records_sql('SELECT * FROM `mdl_schedules`'); $table = new html_table(); $table->head = array('Date','Time', 'A' , 'B', 'C','D', 'E', 'F'); foreach ($rec as $records) { $id = $records->id; $scheduledatet = $records->scheduledate; $scheduletime = $records->scheduletime; $session = $records->s; $venue = $records->v; $trainer = $records->t; $category = $records->c; $course = $records->course; $link = $records->link; $table->data = array(array($scheduledatet, $scheduletime, $a,$b,$c,$d,$e,'<a href="'.$link.'">View</a>')); echo html_writer::table($table); } Any reference or help will be much appreciated.