Hello:
I'm running a script and generating the following message:
Column count doesn't match value count at row 1
I've stared at this thing for a while. Can someone help me out?
Thank you in advance.
Here's the code:
<?php
session_start();
ob_start();
include "conn.inc.php";
?>
<html>
<head>
<title>Beginning PHP5, Apache and MySQL</title>
</head>
<body>
<?php
if (isset($POST['submit']) && $POST['submit'] == "Register") {
if ($POST['username'] != "" &&
$POST['password'] != "" &&
$POST['first_name'] != "" &&
$POST['last_name'] != "" &&
$_POST['memberid'] != "") {
$query = "SELECT username FROM member " .
"WHERE username = '" . $_POST['username'] . "';";
$result = mysql_query($query)
or die(mysql_error());
if (mysql_num_rows($result) != 0) {
?>
<p><font face="verdana" size="2">
<font color="#FF0000"><b>The Username,
<?php echo $POST['username']; ?>, is already in use, please choose
another!</b></font>
<form action="register.php" method="post">
<b>Member ID</b>: <input type="text" name="memberid"
value="<?php echo $POST['memberid']; ?>"><br>
<b>First Name</b>: <input type="text" name="first_name"
value="<?php echo $POST['first_name']; ?>"><br>
<b>Last Name</b>: <input type="text" name="last_name"
value="<?php echo $POST['last_name']; ?>"><br>
<b>Email</b>: <input type="text" name="email"
alue="<?php echo $POST['email']; ?>"><br>
<b>Primary Telephone</b>: <input type="text" name="phone1"
value="<?php echo $POST['phone1']; ?>"><br>
<b>Alternate Telephone</b>: <input type="text" name="phone2"
value="<?php echo $POST['phone2']; ?>"><br><br>
<b>Username</b>: <input type="text" name="username"><br>
<b>Password</b>: <input type="password" name="password"
value="<?php echo $POST['password']; ?>"><br><br>
<input type="submit" name="submit" value="Register">
<input type="reset" value="Clear"></font>
</form>
</p>
<?php
} else {
$query = "insert into member values ('', '$POST[memberid]', '$POST[first_name]', '$POST[last_name]', '$POST[email]',
'$POST[phone1]', '$POST[phone2]', (PASSWORD('$_POST[password]')))";
$result = mysql_query($query)
or die(mysql_error());
?>
<p><font face="verdana" size="2">
Thank you, <?php echo $POST['first_name'] . " " .
$POST['last_name']; ?> for registering!<br></font>
<?php
header("Refresh: 5; URL=index.html");
echo "Your registration is complete! " .
"You are being sent to the page you requested!<br>";
echo "(If your browser doesn't support this, " .
"<a href=\"index.html\">click here</a>)";
die();
}
} else {
?>
<p><font face="verdana" size="2">
<font color="#FF0000"><b>The Username, Password, Email, First Name,
and Last Name fields are required!</b></font>
<form action="register.php" method="post">
<b>Member ID</b>: <input type="text" name="memberid"
value="<?php echo $POST['memberid']; ?>"><br>
<b>First Name</b>: <input type="text" name="first_name"
value="<?php echo $POST['first_name']; ?>"><br>
<b>Last Name</b>: <input type="text" name="last_name"
value="<?php echo $POST['last_name']; ?>"><br>
<b>Email</b>: <input type="text" name="email"
alue="<?php echo $POST['email']; ?>"><br>
<b>Primary Telephone</b>: <input type="text" name="phone1"
value="<?php echo $POST['phone1']; ?>"><br>
<b>Alternate Telephone</b>: <input type="text" name="phone2"
value="<?php echo $POST['phone2']; ?>"><br><br>
<b>Username</b>: <input type="text" name="username"><br>
<b>Password</b>: <input type="password" name="password"
value="<?php echo $_POST['password']; ?>"><br><br>
<input type="submit" name="submit" value="Register">
<input type="reset" value="Clear"></font>
</form>
</p>
<?php
}
} else {
?>
<p><font face="verdana" size="2">
Welcome to the registration page!<br>
The Username, Password, Email, First Name, and Last Name fields
are required!
<form action="register.php" method="post">
<b>Member ID</b>: <input type="text" name="memberid"><br>
<b>First Name</b>: <input type="text" name="first_name"><br>
<b>Last Name</b>: <input type="text" name="last_name"><br>
<b>Email</b>: <input type="text" name="email"><br>
<b>Primary Telephone</b>: <input type="text" name="phone1"><br>
<b>Alternate Telephone</b>: <input type="text" name="phone2"><br><br>
<b>Username</b>: <input type="text" name="username"><br>
<b>Password</b>: <input type="password" name="password"><br>
<input type="submit" name="submit" value="Register">
<input type="reset" value="Clear"></font>
</form>
</p>
<?php
}
?>
</body>
</html>
