Index: admin/browse.php
===================================================================
--- admin/browse.php (revision 9712)
+++ admin/browse.php (working copy)
@@ -367,19 +367,21 @@
$fuqtquestions[] = $field['fieldname'];
}
- // find all responses (filenames) to the fuqt questions
- $query="SELECT " . implode(", ", $fuqtquestions) . " FROM $surveytable where id={$_POST['deleteanswer']}";
- $responses = db_execute_assoc($query) or safe_die("Could not fetch responses
$query
".$connect->ErrorMsg());
+ if (!empty($fuqtquestions)) {
+ // find all responses (filenames) to the fuqt questions
+ $query="SELECT " . implode(", ", $fuqtquestions) . " FROM $surveytable where id={$_POST['deleteanswer']}";
+ $responses = db_execute_assoc($query) or safe_die("Could not fetch responses
$query
".$connect->ErrorMsg());
- while($json = $responses->FetchRow())
- {
- foreach ($fuqtquestions as $fieldname)
+ while($json = $responses->FetchRow())
{
- $phparray = json_decode($json[$fieldname]);
- foreach($phparray as $metadata)
+ foreach ($fuqtquestions as $fieldname)
{
- $path = dirname(getcwd())."/upload/surveys/".$surveyid."/files/";
- unlink($path.$metadata->filename); // delete the file
+ $phparray = json_decode($json[$fieldname]);
+ foreach($phparray as $metadata)
+ {
+ $path = dirname(getcwd())."/upload/surveys/".$surveyid."/files/";
+ unlink($path.$metadata->filename); // delete the file
+ }
}
}
}