[DONE] SQL Delete statement error from admin's customers page.

@Wilt:

From your admin/customers.php file,

change:

while (!$reviews->EOF) {
            $dbExecute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
                        where reviews_id = '" . (int)$reviews['reviews_id'] . "'");
            $reviews->MoveNext();
          }

to read:

while (!$reviews->EOF) {
            $db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
                        where reviews_id = '" . (int)$reviews['reviews_id'] . "'");
            $reviews->MoveNext();
          }

You forgot to call the method name inside the object name as only an unexistent variable name has been set right now. :wink2:

Good catch.

There's another part missing in that same section. The correction is this:```php
while (!$reviews->EOF) {
$db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
where reviews_id = '" . (int)$reviews->fields['reviews_id'] . "'");
$reviews->MoveNext();
}

I don't see another one like that anywhere on the script as I'm using the latest version. Perhaps it was coded afterwords ? :wink2:

$reviews['reviews_id']
vs
$reviews->fields['reviews_id']

Ahh ! yes, I see it now. Very well, thanks for the update.