Hi
I'm attempting to connect a survey up to a db. Everything was working fine until I added a comment box. Now I'm getting the following error. Hope someone can help.
Error:
Query failed: Duplicate entry '0' for key 1
survey code:
<html><head> <title>NCI Process - An InDepth Analysis</title> <style type="text/css"> <!-- .style1 { font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 18px; } .style11 {font-size: 16px} --> </style></head><body><link href="styles.css" rel="stylesheet" type="text/css"><div align="center"> <p class="style1"><img src="nci5.gif" width="140" height="121"></p> <p class="style1">Please answer all questions as honestly as possible! </p></div> <form action="surveyconnect.php" method="post"><div align="center"><table border="1"> <tr> <td><div align="left" class="style11">What gender are you?</div></td> <td colspan="5"><div align="left" class="style11"> <input type="radio" name="gender" value="1"> Male | <input type="radio" name="gender" value="2"> Female</div></td> </tr> <tr> <td><div align="left" class="style11">What is your relationship with the college?</div></td> <td colspan="5"><div align="left" class="style11"> <input type="radio" name="relationship" value="1"> Lecturer | <input type="radio" name="relationship" value="2"> Marketing</div></td> </tr> <tr> <td><div align="left" class="style11">Are you aware of how courses are currently introduced?</div></td> <td colspan="5"><div align="left" class="style11"> <div align="left"> <input type="radio" name="awareness" value="1"> Yes | <input type="radio" name="awareness" value="2"> No </div></td> </tr> <tr> <td><div align="left" class="style11">Do you feel you should be included more in relation to how courses are introduced?</div></td> <td colspan="5"><div align="left" class="style11"> <div align="left"> <input type="radio" name="inclusion" value="1"> Yes | <input type="radio" name="inclusion" value="2"> No </div></td> </tr> <tr> <td><div align="left" class="style11">Would it be a good idea to get feedback from students about potentially new courses?</div></td> <td colspan="5"><div align="left" class="style11"> <div align="left"> <input type="radio" name="studentfeedback" value="1"> Yes | <input type="radio" name="studentfeedback" value="2"> No </div></td> </tr> <tr> <td><div align="left" class="style11">How satisfied are you in relation to how courses are currently introduced? (1=not very, 4=very) </div></td> <td><div align="left" class="style11"> <input type="radio" name="satisfaction" value="1" /> 1</div></td> <td><div align="left" class="style11"> <input type="radio" name="satisfaction" value="2" /> 2</div></td> <td><div align="left" class="style11"> <input type="radio" name="satisfaction" value="3" /> 3</div></td> <td><div align="left" class="style11"> <input type="radio" name="satisfaction" value="4" /> 4</div></td> </tr> <tr> <td><div align="left" class="style11">Additional Comments:</div></td> <td colspan="5"><div align="left" class="style11"> <div align="left"> <textarea rows="3" cols="20"></textarea><br /> </div></td> </tr> </table> <br /> <input type="submit" value="Submit" name="Submit" /> <input name="reset" type="reset" value="Reset" /> <br> <br> </div></form></body></html>
surveyconnect code:
<?PHPrequire "db_survey.php";$link = mysql_connect("localhost","sea10004_jack4","gladiator44","sea10004_survey"); // connection to databasif ( !$link ) exit ( "Database error: " . mysql_error() );mysql_select_db ( $db_name, $link ); // selects database name $gender = $_POST ['gender']; $relationship = $_POST ['relationship']; $awareness = $_POST ['awareness']; $inclusion = $_POST ['inclusion']; $studentfeedback = $_POST ['studentfeedback']; $satisfaction = $_POST ['satisfaction']; $comments = $_POST ['comments']; $result = mysql_query( "INSERT INTO onlinesurvey (gender, relationship, awareness, inclusion, studentfeedback, satisfaction, comments) VALUES('$gender', '$relationship','$awareness','$inclusion','$studentfeedback','$satisfaction','$comments')", $link ); // insert post into db if( !$result ) exit ( "Query failed: " . mysql_error() );?><html> <head> <title>Results</title> <style type="text/css"> <!-- .style1 { font-size: 24px; font-weight: bold; } --> </style></head><body> <div align="center" class="style1"> <p> </p> <p> </p> <p>Thank you for taking the time to complete the survey.</p> <p> </p> <p> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="103" height="24"> <param name="movie" value="button1.swf"> <param name="quality" value="high"> <embed src="button1.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="103" height="24" ></embed> </object> </p> </div> </body></html>
