title: crud delete all rows
body: <p>I'm trying to delete all rows from my database using crud and this is my delete response page.
  I tried the query delete * but that didn't work so I've manually typed it up like this. The values are coming up as unidentified indexes. Can anyone help, tell me what I'm doing wrong or give an easier method please?</p>
  
  <pre><code>&lt;?php 
  include "library.php"; 
  include "database.php";
  ?&gt;
  
  
  &lt;?php
  //Get data from form
  $faculty=$_POST["faculty"];
  $date=$_POST["date"];
  $modulecode=$_POST["modulecode"];
  $moduletitle=$_POST["moduletitle"];
  $school=$_POST["school"];
  $modulebookcontent=$_POST["modulebookcontent"];
  $moduleorganisation=$_POST["moduleorganisation"];
  $lrcmaterials=$_POST["lrcmaterials"];
  $moduledifficulty=$_POST["moduledifficulty"];
  $modulesimilarity=$_POST["modulesimilarity"];
  $contentinteresting=$_POST["contentinteresting"];
  $previousknowledge=$_POST["previousknowledge"];
  $understoodassessmentrequirements=$_POST["understoodassessmentrequirements"];
  $assessmentmethod=$_POST["assessmentmethod"];
  $markedwork=$_POST["markedwork"];
  $ML_interestforsubject=$_POST["ML_interestforsubject"];
  $ML_contentclear=$_POST["ML_contentclear"];
  $ML_appropriateteachingpace=$_POST["ML_appropriateteachingpace"];
  $ML_reachableforadvice=$_POST["ML_reachableforadvice"];
  $ML_helpfulfeedback=$_POST["ML_helpfulfeedback"];
  $L1_interestforsubject=$_POST["L1_interestforsubject"];
  $L1_contentclear=$_POST["L1_contentclear"];
  $L1_appropriateteachingpace=$_POST["L1_appropriateteachingpace"];
  $L1_reachableforadvice=$_POST["L1_reachableforadvice"];
  $L1_helpfulfeedback=$_POST["L1_helpfulfeedback"];
  $L2_interestforsubject=$_POST["L2_interestforsubject"];
  $L2_contentclear=$_POST["L2_contentclear"];
  $L2_appropriateteachingpace=$_POST["L2_appropriateteachingpace"];
  $L2_reachableforadvice=$_POST["L2_reachableforadvice"];
  $L2_helpfulfeedback=$_POST["L2_helpfulfeedback"];
  $moduleleader=$_POST["moduleleader"];
  $lecturer1=$_POST["lecturer1"];
  $lecturer2=$_POST["lecturer2"];
  $indpstudy=$_POST["indpstudy"];
  $attendance=$_POST["attendance"];
  $bestfeatures=$_POST["bestfeatures"];
  $improvemodule=$_POST["improvemodule"];
  
  
  $queryString = "delete from studentanswers where faculty=".$faculty; 
  $queryString = "delete from studentanswers where date=".$date; 
  $queryString = "delete from studentanswers where modulecode=".$modulecode; 
  $queryString = "delete from studentanswers where moduletitle=".$moduletitle;
  $queryString = "delete from studentanswers where school=".$school; 
  $queryString = "delete from studentanswers where modulebookcontent=".$modulebookcontent; 
  $queryString = "delete from studentanswers where moduleorganisation=".$moduleorganisation; 
  $queryString = "delete from studentanswers where lrcmaterials=".$lrcmaterials; 
  $queryString = "delete from studentanswers where moduledifficulty=".$moduledifficulty; 
  $queryString = "delete from studentanswers where modulesimilarity=".$modulesimilarity; 
  $queryString = "delete from studentanswers where contentinteresting=".$contentinteresting; 
  $queryString = "delete from studentanswers where previousknowledge=".$previousknowledge; 
  $queryString = "delete from studentanswers where understoodassessmentrequirements=".$understoodassessmentrequirements; 
  $queryString = "delete from studentanswers where assessmentmethod=".$assessmentmethod; 
  $queryString = "delete from studentanswers where markedwork=".$markedwork; 
  $queryString = "delete from studentanswers where ML_interestforsubject=".$ML_interestforsubject;
  $queryString = "delete from studentanswers where ML_contentclear=".$ML_contentclear; 
  $queryString = "delete from studentanswers where ML_appropriateteachingpace=".$ML_appropriateteachingpace; 
  $queryString = "delete from studentanswers where ML_reachableforadvice=".$ML_reachableforadvice;
  $queryString = "delete from studentanswers where ML_helpfulfeedback=".$ML_helpfulfeedback; 
  $queryString = "delete from studentanswers where L1_interestforsubject=".$L1_interestforsubject; 
  $queryString = "delete from studentanswers where L1_contentclear=".$L1_contentclear;
  $queryString = "delete from studentanswers where L1_appropriateteachingpace=".$L1_appropriateteachingpace; 
  $queryString = "delete from studentanswers where L1_reachableforadvice=".$L1_reachableforadvice; 
  $queryString = "delete from studentanswers where L1_helpfulfeedback=".$L1_helpfulfeedback;
  $queryString = "delete from studentanswers where L2_interestforsubject=".$L2_interestforsubject; 
  $queryString = "delete from studentanswers where L2_contentclear=".$L2_contentclear; 
  $queryString = "delete from studentanswers where L2_appropriateteachingpace=".$L2_appropriateteachingpace;
  $queryString = "delete from studentanswers where L2_reachableforadvice=".$L2_reachableforadvice; 
  $queryString = "delete from studentanswers where L2_helpfulfeedback=".$L2_helpfulfeedback; 
  $queryString = "delete from studentanswers where moduleleader=".$moduleleader;
  $queryString = "delete from studentanswers where lecturer1=".$lecturer1; 
  $queryString = "delete from studentanswers where lecturer2=".$lecturer2; 
  $queryString = "delete from studentanswers where indpstudy=".$indpstudy; 
  $queryString = "delete from studentanswers where attendance=".$attendance;
  $queryString = "delete from studentanswers where bestfeatures=".$bestfeatures; 
  $queryString = "delete from studentanswers where improvemodule=".$improvemodule;
  
  
  queryDatabase($queryString);
  ?&gt;
  
  
  &lt;?php CRUDheader("Delete Student Answers"); ?&gt;
  
  &lt;body&gt;
  
  &lt;div id="main"&gt;
  
  &lt;div id="content"&gt;
  &lt;p&gt;Student answers deleted&lt;/p&gt;  
  &lt;/div&gt;  
  
  &lt;/div&gt;&lt;?php CRUDmain(); ?&gt;
  
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>