Changeset 1897 in ExiteCMS for trunk/administration/reports.php

Timestamp:

10/20/08 17:26:17 (4 years ago)

Author:

hverton

Message:

fixed not selecting the correct record in edit mode

File:

• trunk/administration/reports.php (modified) (1 diff)

trunk/administration/reports.php

@@ -61 +61 @@
 // edit an existing report definition
 if ($action == "edit" && !isset($variables['report'])) {
-    $result = dbquery("SELECT r.*, m.mod_folder FROM ".$db_prefix."reports r LEFT JOIN ".$db_prefix."modules m ON r.report_mod_id = m.mod_id");
+    $result = dbquery("SELECT r.*, m.mod_folder FROM ".$db_prefix."reports r LEFT JOIN ".$db_prefix."modules m ON r.report_mod_id = m.mod_id WHERE report_id = $report_id");
     if ($data = dbarray($result)) {
         // get the title for this report