yuencr20

I'm trying to impliment a tracker to save progress for viewing an online web module for our department. It is a flash module that is broken into four separate modules. We have an existing evaluation form that runs to server, but it only takes info and stores it. Students will need to enter normal demographic information and create a password,but we need it to be possible to save their progress so that they can come back to it later. We don't need it to track too in depth but at least to the module that they have reached. I had planned on just making 4 separate html pages that preceeded each module that only linked to the next, but it seems that people won't be able to finish in it one sitting, hence the tracker is needed. if anyone can help or correspond back with me to get me started that would be much appreciated. Thanks, Ryan

HELP, I have an online Evaluation form where the info needs to be stored in a mysql DB. The only problem that I'm running into is that I have a few tables that there are multiple checkboxes, where the multiple values need to be stored in the same columb of that row. Right now it's just taking the last value entered and submiting that into the columb. Ex.. If the a person enters values {3,5,&7}..... I want {3,5,7} to show up in one row rather than just {7}. How can this be done? I am using an early version of both PHP Coder and Mysql just for general information. Here is some html code of the table with multiple checkboxes: <tr> <td valign="top" height="205"> <blockquote> <p>Do you work in any of the following places?<br> <b>(check all that apply)</b></p> </blockquote> <table width="86%" border="0"> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="1"> </td> <td width="54%">Community Health Center</td> <td width="3%"> <input type="checkbox" name="following_places" value="8"> </td> <td width="36%">Migrant Health Center </td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="2"> </td> <td width="54%">Health Care for Homeless Center</td> <td width="3%"> <input type="checkbox" name="following_places" value="9"> </td> <td width="36%">Public Housing Primary Care Center</td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="3"> </td> <td width="54%">Rural Health Clinic</td> <td width="3%"> <input type="checkbox" name="following_places" value="10"> </td> <td width="36%">Community Mental HEalth Center</td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="4"> </td> <td width="54%">National Health Service Corps Site</td> <td width="3%"> <input type="checkbox" name="following_places" value="11"> </td> <td width="36%">Indian Health Services</td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="5"> </td> <td width="54%">Federally-Qualified Health Center</td> <td width="3%"> <input type="checkbox" name="following_places" value="12"> </td> <td width="36%">State or Local Health Department</td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="6"> </td> <td width="54%">Ambulatory Practice Sites Designated By Stae Governors</td> <td width="3%"> <input type="checkbox" name="following_places" value="13"> </td> <td width="36%">Public Health Hospital</td> </tr> <tr valign="top"> <td width="4%"> </td> <td width="3%"> <input type="checkbox" name="following_places" value="7"> </td> <td width="54%">HPSA (Federally Designated Health Proffesionals Storage Area </td> <td width="3%"> </td> <td width="36%"> </td> </tr> </table> </td> </tr> Here is the PHP code that stores all of the corresponding info into the DB: <? //PROCESS THE FORM// $connection = mysql_connect ("localhost", "derek", "geradmin") or die ("Could not connect"); if ($connection){ //echo "Connected to database... <br>"; //echo "Processing data... <br>"; //SELECTING PROPER DATABASE AND TABLE $dbname = "gerdbase"; $tableName = "test_eval"; $dbs = mysql_select_db ($dbname, $connection) or die ("Could not select database"); //*************************PROCESS DATA SENT TO PAGE**********************// //RACE DATA if ($race_other == ""){ $race_other = "null"; } if ($race != "8"){ $race_other = "null"; } //CITY AND COUNTY DATA if ($w_city == ""){ $w_city = "null"; } if ($w_county == ""){ $w_county = "null"; } //EDUCATION DATA if ($education_other == ""){ $education_other = "null"; } if ($education != "6"){ $education_other = "null"; } //DEGREES AND CERTIFICATES DATA $d_cs = ""; if (sizeof($degrees_certs) < 5){ $extra = 5 - sizeof($degrees_certs); $add = ""; for ($j = 0; $j < $extra; $j++){ $add .= "0_"; } for ($i = 0; $i < sizeof($degrees_certs); $i++){ $d_cs .= "$degrees_certs[$i]_"; } $d_cs .= "" . $add; } else { for ($i = 0; $i < 5; $i++){ $d_cs .= "$degrees_certs[$i]_"; } } if ($degrees_certs_other == ""){ $degrees_certs_other = "null"; } //FORMAL TRAINING DATA $fty = array ('0', '0', '0', '0', '0', '0', '0', '0'); $fty_text = ""; if ((sizeof($formal_train_yes) == 0) || ($formal_train == "2")){ $fty_text = " _ _ _ _ _ _ _ _"; $formal_train_yes_other = "null"; } else { for ($i = 0; $i < sizeof($formal_train_yes); $i++){ $val = trim($formal_train_yes[$i]); settype ($val, "integer"); $ind = $val - 1; $fty[$ind] = '1'; } for ($k = 0; $k < sizeof($fty); $k++){ $fty_text .= $fty[$k] . "_"; } } if ($formal_train_yes_other == "") { $formal_train_yes_other = "null"; } //DISCIPLINE/PROFESSION DATA if (($dis_prof_other1 == "") && ($dis_prof_other2 == "") && ($dis_prof_other3 == "")){ $dis_prof_other = "null"; } else { if ($dis_prof_other1 != ""){ $dis_prof_other = $dis_prof_other1; } else { if ($dis_prof_other2 != ""){ $dis_prof_other = $dis_prof_other2; } else { if ($dis_prof_other3 != ""){ $dis_prof_other = $dis_prof_other3; } } } }//end else $dis if (($dis_prof != "34") && ($dis_prof != "21") && ($dis_prof != "31")){ $dis_prof_other = "null"; } //PLACE OF EMPLOYMENT DATA if ($place_employ_o == ""){ $place_employ_o = "null"; } if ($place_employ != "14"){ $place_employ_o = "null"; } //*******************************END PROCESSING DATA TO PAGE************************** /************FOR TESTING PURPOSES TO CHECK VALUES************************** ECHO OUT VALUES BEING SUBMITTED echo "Id: $id <br>"; echo "Date: $date <br>"; echo "Gender: $gender <br>"; echo "Age: $age <br>"; echo "Race: $race ($race_other)<br>"; echo "Work City: $w_city <br>"; echo "Work County: $w_county <br>"; echo "Work State: $w_state <br>"; echo "Place of Work: $following_places <br>"; echo "Education: $education ($education_other) <br>"; echo "Degrees/Certificates: $degree_certs ($degrees_certs_other) <br>"; echo "Formal Training: $formal_training <br>"; echo " Yes (string): $fty_text ($formal_train_yes_other) <br>"; echo "Discipline: $discipline ($discipline_other) <br>"; echo "Faculty Member: $faculty_member <br>"; echo "Place of Employment: $place_employ ($place_employ_o) <br>"; echo "Job Title: $job_title <br>"; echo "Primary Role: $primary_role ($primary_role_other) <br>"; echo "Older Adults: $older_adults <br>"; echo "Isolate People: $isolated_people <br>"; echo "Disadvantages: $disadvantages <br>"; echo "Minority: $minority <br>"; ***********************************************************************/ //******************PUT VALUES INTO THE DATABASE****************** settype ($id, "integer"); settype ($gender, "integer"); settype ($age, "integer"); settype ($race, "integer"); settype ($following_places, "integer"); settype ($education, "integer"); settype ($degree_certs, "integer"); settype ($formal_training, "integer"); settype ($formal_train_yes, "integer"); settype ($discipline, "integer"); settype ($faculty_member, "integer"); settype ($place_employ, "integer"); settype ($primary_role, "integer"); settype ($older_adults, "integer"); settype ($isolated_people, "integer"); settype ($disadvantages, "integer"); settype ($minority, "integer"); $sql_insert = "INSERT INTO $tableName "; $sql_insert .= "(id, date, gender, age, race, race_other, w_city, w_county, w_state, following_places, education, education_other, degree_certs, degrees_certs_other, formal_training, formal_train_yes, formal_train_yes_other, discipline, discipline_other, faculty_member, place_employ, place_employ_other, job_title, primary_role, primary_role_other, older_adults, isolated_people, disadvantages, minority)"; $sql_insert .= "VALUES (\"$id\", \"$date\", \"$gender\", \"$age\", \"$race\", \"$race_other\", \"$w_city\", \"$w_county\","; $sql_insert .= "\"$w_state\", \"$following_places\", \"$education\", \"$education_other\", \"$degree_certs\","; $sql_insert .= "\"$degrees_certs_other\", \"$formal_training\", \"$fty_text\", \"$formal_train_yes_other\","; $sql_insert .= "\"$discipline\", \"$discipline_other\", \"$faculty_member\", \"$place_employ\","; $sql_insert .= "\"$place_employ_o\", \"$job_title\", \"$primary_role\", \"$primary_role_other\", \"$older_adults\", \"$isolated_people\", \"$disadvantages\", \"$minority\")"; $result = mysql_query ($sql_insert,$connection) or die ("Couldn't execute query. The query string was: $sql_insert"); echo "<font size\"4\"><b>Thank you for taking the time to fill in the demographic<br>"; echo "Your data has been stored...Follow the link below to continue.<b></font><br>"; echo "<a href=\"http://www.sahp.vcu.edu/gerontology/index.html\"> Main page</a>"; } else{ //DATABASE IS DOWN...FORWARD THEM TO THE SITE echo "Oops!! DATABASE MUST BE DOWN"; }// end else --> database is down ?> Can anyone help me? Thanks