From b3d4840d396c68d399e2a22a320ba5ebe1ffe1d2 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Mon, 26 Jun 2006 16:16:43 +0000
Subject: [PATCH] assignments on mymoodle page, Bug #5839 - Found more than one
 record in get_record_sql !; merged from MOODLE_16_STABLE

---
 mod/assignment/lib.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/mod/assignment/lib.php b/mod/assignment/lib.php
index 487e1d7bfb..af9008cf30 100644
--- a/mod/assignment/lib.php
+++ b/mod/assignment/lib.php
@@ -2358,7 +2358,8 @@ function assignment_print_overview($courses, &$htmlarray) {
         } else {
             $sql = "SELECT *
                       FROM {$CFG->prefix}assignment_submissions
-                     WHERE userid = '$USER->id'";
+                     WHERE userid = '$USER->id'
+                       AND assignment = '{$assignment->id}'";
             if ($submission = get_record_sql($sql)) {
                 if ($submission->teacher == 0 && $submission->timemarked == 0) {
                     $str .= $strsubmitted . ', ' . $strnotgradedyet;
-- 
2.39.5