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

[TheOracle]

@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.

[DrByte]

Good catch.

There's another part missing in that same section. The correction is this:

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

[TheOracle]

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

[DrByte]

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

[TheOracle]

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