Custom Scheduled Tasks

I created a custom scheduled task with a query in the database that aims to return all elements of the accounts_cstm table, but this query is returning only the first row of the database.

You need to loop through each resource element. example :

$oRes = $db->query($sql);

while($aRowAcc = $db->fetchByAssoc($oRes)) {

}
1 Like

Thnks for reply!! I already figure out, my problem was on the db->query. I just put the string right inside the parenthesis and it worked

Cheers!!