How to LIMIT Retrieved Records ?

How to LIMIT Retrieved Records ?

av mohamed salman -
Antall svar: 1

I want LIMIT Retrieved records from database  
when write this query no records retrieved from database 

  $sql = 'SELECT DISTINCT  meetingid, bigbluebuttonbnid FROM {bigbluebuttonbn_logs} WHERE ';
    $sql .= '(bigbluebuttonbnid='.implode(' OR bigbluebuttonbnid=', array_keys($bigbluebuttonbns)).')';
    // Include only Create events and exclude those with record not true.
    $sql .= "AND log = ? AND meta LIKE ? AND meta LIKE ? LIMIT 1,3  ";


$records = $DB->get_records_sql_menu($sql, array(BIGBLUEBUTTONBN_LOG_EVENT_CREATE, '%record%', '%true%'));

Gjennomsnittlig vurdering: -