Please help me convert this php to CI code

[eluser]Jbeasley6651[/eluser]
$listingCounter = 1;
foreach ($updateRecordsArray as $recordIDValue) {

$query = "UPDATE records SET recordListingID = " . $listingCounter . " WHERE recordID = " . $recordIDValue;
mysql_query($query) or die('Error, insert query failed');
$listingCounter = $listingCounter + 1;
}



I'm use to CAKE as a framework and i'm still learning CI have stand alone php/ajax code that works fine and i really need help converting it to code igniter.

I'm placing this inside a controller (i'm opting out of models at the moment).

For cake it would be something like...

foreach ($updateRecordsArray as $recordIDValue) {
$this->Record->id = $recordIdValue;
$this->Record->saveField('recordListingID', $listingCounter);
}