How to Get Count from Last Delete Query - Row Affected?

[kwright]

Greetings,

I've created some custom code to delete some records via admin using the query factory class. It works, but don't know how to get a count of how many records were affected / deleted?

I tried this, but it doesn't return any results...

$del_sql = 'My Delete Query';
$del_results = $db->Execute($del_sql);
$count = $del_results->RecordCount();
echo $count; 

Suggestions?

Thanks

[lat9]

@kwright, thanks for making me go and look. This functionality really should be part of the Zen Cart queryFactory class to provide portability, but here's a snippet that will work only for Zen Cart v1.5.3 and later (since they use the mysqli form of database interface):

count = mysqli_affected_rows ($db->link);

That should return the count of affected rows for the previous UPDATE, INSERT, REPLACE or DELETE query, per the function's documentation.

Be sure to comment the heck out of that statement, just in case the built-in database engine changes again in the future!

[kwright]

@kwright, thanks for making me go and look. This functionality really should be part of the Zen Cart queryFactory class to provide portability, but here's a snippet that will work only for Zen Cart v1.5.3 and later (since they use the mysqli form of database interface):

count = mysqli_affected_rows ($db->link);

That should return the count of affected rows for the previous UPDATE, INSERT, REPLACE or DELETE query, per the function's documentation.

Be sure to comment the heck out of that statement, just in case the built-in database engine changes again in the future!

Thanks lat9,

That did it!

I too would agree that this would be very helpful to have integrated into the queryFactory class.

[lat9]

Woo-hoo! Thanks for letting me know that the code fragment worked. I'll note the suggested change to the queryFactory class.