Hi all I'm a new moodle user. I would like to ask you if I have a code
>> $strSQL = "select subid,name from table1 where id = $id and stepid=$stepid";
How could I code in moodle style.
Thanks
You are probably looking for
$data = get_record('table1', 'id', $id, 'stepid', $stepid, '', '', 'subid,name');
the get_record function (and many others) are defined in lib/dmllib.php.
$data = get_record('table1', 'id', $id, 'stepid', $stepid, '', '', 'subid,name');
the get_record function (and many others) are defined in lib/dmllib.php.
Thank you Tim your suggestion is very useful for me ^o^