Jump to content

Archived

This topic is now archived and is closed to further replies.

whare

Column count doesn't match value count at row 1

Recommended Posts

sorry new at php and dont understand the error

[quote]Column count doesn't match value count at row 1[/quote]


Anybody?

Share this post


Link to post
Share on other sites
[code]<?php
include "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 :)

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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??

Share this post


Link to post
Share on other sites
Make a hidden field for it, that has the value of whatever it will be. For example:

[code]
<?php
include "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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.