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] 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] 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
Archived
This topic is now archived and is closed to further replies.