Sorry, using the wildcards (%%) for subject_id and experiment_id and clicking \"Delete all sessions for this subject\" would delete all Ensemble sessions. This is prohibited as a safegaurd.");
}
else {
//get response table(s) for experiment(s)
$sql_get_response_tables = sprintf("select * from experiment where experiment_id like %s",GetSQLValueString($_POST['experiment_id'],"text"));
$get_response_tables = mysql_query($sql_get_response_tables) or die(mysql_error());
//delete from response table
while($record_response_table = mysql_fetch_assoc($get_response_tables)) {
$response_table = $record_response_table['response_table'];
if(isset($_POST['delete_all_sessions']) && ($_POST['delete_all_sessions'] == 1))
$sql_delete_responses = sprintf("delete from %s where subject_id like %s",$response_table,GetSQLValueString($subject_id,"text"));
else
$sql_delete_responses = sprintf("delete from %s where session_id=%d and subject_id like \"%s\"",$response_table,$session_id,$subject_id);
echo $sql_delete_responses."
";
$success_delete_responses = mysql_query($sql_delete_responses) or die(mysql_error());
if($success_delete_responses>=0)
echo mysql_affected_rows()." rows affected.
";
else
echo "Query failed.";
}
//delete from session table
if(isset($_POST['delete_all_sessions']) && ($_POST['delete_all_sessions'] == 1))
$sql_delete_session = sprintf("delete from session where subject_id like %s and experiment_id like %s",
GetSQLValueString($subject_id,"text"),GetSQLValueString($experiment_id,"text"));
else
$sql_delete_session = sprintf("delete from session where session_id=%d and experiment_id like %s",$session_id,GetSQLValueString($experiment_id,"text"));
echo $sql_delete_session."
";
$success_delete_session = mysql_query($sql_delete_session) or die(mysql_error());
if($success_delete_session >=0)
echo mysql_affected_rows()." rows affected.
";
else
echo "Query failed.";
}
printf("Go to Ensemble Cleaner
",$questionnaire_location);
printf("Go to Experiment Editor
",$questionnaire_location);
?>