" . mysql_error()); // print the question and the categories associated with it while ($row2 = mysql_fetch_array($result2)){ $question_id = $row2['question_id']; $question_text = $row2['question_text']; $cat_1 = $row2['category_1']; $cat_2 = $row2['category_2']; $cat_3 = $row2['category_3']; $cat_4 = $row2['category_4']; $cat_5 = $row2['category_5']; $cat_6 = $row2['category_6']; $cat_7 = $row2['category_7']; $cats_to_display = ""; if ($cat_1){ $cats_to_display .= "1 "; } if ($cat_2){ $cats_to_display .= "2 "; } if ($cat_3){ $cats_to_display .= "3 "; } if ($cat_4){ $cats_to_display .= "4 "; } if ($cat_5){ $cats_to_display .= "5 "; } if ($cat_6){ $cats_to_display .= "6 "; } if ($cat_7){ $cats_to_display .= "7 "; } echo ""; echo ""; echo" add "; echo ""; /*// add link to invisible processing page to add this question to the survey echo ""; ";*/ echo "$question_text $cats_to_display"; echo ""; } }// end of function display_all_questions_for_category() ?>

Edit the 360° Feedback Survey

 

"; echo ""; echo ""; echo ""; echo ""; }//end of while loop dealing with questions for this survey ?>

 

Question Pool

"; $sql = "SELECT * FROM tbl_q_categories"; $result = mysql_query($sql, $connection) or die("could not get categories" . mysql_error()); while ($row = mysql_fetch_array($result)){// for each category //setting the current category id and category title $q_category_id = $row['q_category_id']; $q_category_title = $row['q_category_title']; // display a row showing the category title echo ""; echo "";//empty cell echo " ";//print the category echo "";// echo ""; display_all_questions_for_category($q_category_id); $next_cat = $q_category_id + 1; // blank row between categories echo " "; // }// end of while loop for categories echo""; ?>
Use question
in survey
Question Text Categories
     
   
$q_category_id. $q_category_title



Survey

"; ?>
Remove Question
From Survey
Order
"; echo" remove "; echo"
$question_text



Add New Question


 

 

" . mysql_error()); while ($row = mysql_fetch_array($result)){ $cat_id = $row['q_category_id']; $cat_title = $row['q_category_title']; $check_box_name = "category_" . $cat_id; echo " "; } ?>
$cat_id. $cat_title