\r
//check if student id (public field) is already being used\r
if (!$_POST['overwrite'] && !empty($_POST['student_id'])) {\r
- $result = mysql_query("SELECT * FROM ".TABLE_PREFIX."master_list WHERE public_field='$_POST[student_id]' && member_id<>0",$db);\r
+ $result = mysql_query("SELECT public_field FROM ".TABLE_PREFIX."master_list WHERE public_field='$_POST[student_id]' AND member_id<>0 AND member_id<>$id",$db);\r
if (mysql_num_rows($result) != 0) {\r
$msg->addError('CREATE_MASTER_USED');\r
}\r