whare Posted August 6, 2006 Share Posted August 6, 2006 sorry new at php and dont understand the error[quote]Column count doesn't match value count at row 1[/quote]Anybody? Quote Link to comment Share on other sites More sharing options...
hostfreak Posted August 6, 2006 Share Posted August 6, 2006 Can you post you code? Quote Link to comment Share on other sites More sharing options...
whare Posted August 6, 2006 Author Share Posted August 6, 2006 [code]<?phpinclude "db.php";$pilotid = $_POST['pilotid'];$flightnumber = $_POST['flightnumber'];$depair = $_POST['depair'];$deptime = $_POST['deptime'];$arair = $_POST['arair'];$artime = $_POST['artime'];$flighttime = $_POST['flighttime'];$flightinfo = $_POST['flightinfo'];$username = $_POST['username'];$password = $_POST['password'];$result = mysql_query("SELECT * FROM users")or die(mysql_error()); $row = mysql_fetch_array( $result );//$password = md5($password);$flighttotal = $flighttime + $row['flighttotal'];//if($password == $row['password']){// }//if($_SESSION['username'] == $username){// }$sql = mysql_query("INSERT INTO pirep (pilotid, flightnumber, depair, deptime, arair, artime, flighttime, flightinfo, pirep_date, flighttotal) VALUES('$pilotid','$flightnumber','$depair','$deptime','$arair','$artime','$flighttime','$flightinfo','$flighttotal')") or die (mysql_error());// echo "Thank you for your pirep.<br />Your information has been sent to our database pending review from our team.?>[/code]now the areas that have "//" i am alos trying to get working but comming up with other errors but one thing at a time :) Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted August 6, 2006 Share Posted August 6, 2006 You're trying to insert 9 values into 10 fields. The number of values needs to be the same as the number for fields.Ken Quote Link to comment Share on other sites More sharing options...
whare Posted August 6, 2006 Author Share Posted August 6, 2006 ohh right i c i think so how do i use the "pirep_date one then coz that needs to be filled when the file is run?? Quote Link to comment Share on other sites More sharing options...
hostfreak Posted August 6, 2006 Share Posted August 6, 2006 Make a hidden field for it, that has the value of whatever it will be. For example:[code]<?phpinclude "db.php";$pilotid = $_POST['pilotid'];$flightnumber = $_POST['flightnumber'];$depair = $_POST['depair'];$deptime = $_POST['deptime'];$arair = $_POST['arair'];$artime = $_POST['artime'];$flighttime = $_POST['flighttime'];$flightinfo = $_POST['flightinfo'];$pirep_date = $_POST['pirep_date'];$username = $_POST['username'];$password = $_POST['password'];$result = mysql_query("SELECT * FROM users")or die(mysql_error()); $row = mysql_fetch_array( $result );//$password = md5($password);$flighttotal = $flighttime + $row['flighttotal'];//if($password == $row['password']){// }//if($_SESSION['username'] == $username){// }$sql = mysql_query("INSERT INTO pirep (pilotid, flightnumber, depair, deptime, arair, artime, flighttime, flightinfo, pirep_date, flighttotal) VALUES('$pilotid','$flightnumber','$depair','$deptime','$arair','$artime','$flighttime','$flightinfo','$pirep_date','$flighttotal')") or die (mysql_error());// echo "Thank you for your pirep.<br />Your information has been sent to our database pending review from our team.?>[/code]Then wherever you have your form, somewhere add:[code]<input type="hidden" name="pirep_date" value="<?php echo date("F, j, Y"); ?>">[/code]With that, the current date (As: Month, Day, Year e.x August, 6, 2006) will be inserted into pirep_date.None the less, if you are inserting a value, you need to have a field for it. Quote Link to comment 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.