cron job to update data

PHPMaker General Discussion (PHPMaker)
1

I am trying to setup a cron job to update data. I have created a php file similiar to the following:

<?php namespace PHPMaker2020\0101; include_once "autoload.php"; // Open connection if (!isset($GLOBALS["Conn"])) $GLOBALS["Conn"] = GetConnection(); //query trnsxtn_recur table for records where the date equals today $sql = "SELECT id " . "FROM trnsxtn_recur " . "WHERE next_date = '" . $today . "';"; $rs = ExecuteRows($sql); ... additional code CloseConnections(); exit(); //terminate current script ?>

I am trying to utilize methods such as $rs->MoveFirst, $rs->fields[0], $rs->EOF, etc
The function ExecuteRows() returns an array and the above methods are not available.

Any suggestions on how I can utilize the MySqlConnection class methods as mentioned above

Thanks in advance for any help

2

You may use Execute() if you want to return a recordset.