billshackle Posted March 17, 2006 Share Posted March 17, 2006 I have the following error: Column count doesn't match value count at row 1with this script. i can't seem to find anything obvious in my script that causes this - if anyone could shed light. Would appreciate it. Script:[code]<? $username="";$password="";$database="";mysql_connect(localhost,$username,$password);@mysql_select_db($database) or die( "Unable to select database");if (isset($_POST['Submit'])) { $vid = $_POST['vid']; $name = $_POST['name']; $uid = $_POST['uid']; $q1 = $_POST['q1']; $q2 = $_POST['q2']; $q3 = $_POST['q3']; $q4 = $_POST['q4']; $q5 = $_POST['q5']; $comments = $_POST['comments']; $q6 = $_POST['q6']; $query = "INSERT INTO `survey` ( `vid` , `uid` , `name` , `q1` , `q2` , `q3` , `q4` , `q5` , `comments` , `q6` )"; mysql_query($query) or die (mysql_error());}?> <form action="rating.php" method="post"><body><table width="604" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4"> <tr> <td>Name: <br> <input name="name" type="text" /> <br /> <td> <td>UID:<br> <input type="uid" name="uid" value="<? echo $id; ?>"> <td> <tr> </tr><tr> <td colspan="4"></td> </tr> <tr> <td width="156"> <select name="q1"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td colspan="3"><label></label></td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q2"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td width="118"> </td> <td width="316" colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q3"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q4"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q5"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">Comments:</td> </tr> <tr> <td colspan="4"> <textarea name="comments" cols="80" rows="4"></textarea> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q6"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select><input name="Submit" type="Submit" /> <p> </form></td> <td></td> <td colspan="2"> </td> </tr></table></p></body></html>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/5147-error-column-count-doesnt-match-value-count-at-row-1/ Share on other sites More sharing options...
Prismatic Posted March 17, 2006 Share Posted March 17, 2006 Change:[code]$query = "INSERT INTO `survey` ( `vid` , `uid` , `name` , `q1` , `q2` , `q3` , `q4` , `q5` , `comments` , `q6` )";[/code]To:[code]$query = "INSERT INTO survey ('vid' , 'uid' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6') VALUES ('$vid', '$name', '$uid', '$q1', '$q2', '$q3', '$q4', '$q5', '$comments', '$q6')";[/code] Quote Link to comment https://forums.phpfreaks.com/topic/5147-error-column-count-doesnt-match-value-count-at-row-1/#findComment-18284 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.