inserting data into MySql database

[byte_me]

<form action="formresult.php" method="post">
<table><tr><td>
Username<br></td><td><input type="text" name="username" size="14" value="">
<br></td></tr><tr><td>
Password<br></td><td>
<input type="password" name="password" size="10" value="">
<br></td></tr><tr><td>
First Name <br></td><td>
<input type="text" name="firstName" size="30" value=""><br></td></tr><td>Last Name <br></td>
<td><input type="text" name="lastName" size="30" value=""><br></td></tr>
<tr><td>Email Address <br></td>
<td><input type="text" name="emailAddress" size="40" value=""></td></tr></table><input type="submit" value="send">
</form>

formresult.php..............
this stops at line 4

if(isset($HTTP_POST_VARS['submit'])){
if(strlen($HTTP_POST_VARS['username'])>0){
require_once ("/home/shopping/public_html/golf/connect.inc")
$username=$HTTP_POST_VARS['username']; //line 4
$password=$HTTP_POST_VARS['password'];
$firstName=$HTTP_POST_VARS['firstName'];
$lastName=$HTTP_POST_VARS['lastName'];
$emailAddress=$HTTP_POST_VARS['emailAddress'];
$whoCreated=$HTTP_POST_VARS['username'];
$whoUpdated=$HTTP_POST_VARS['username'];
$whenUpdated = time();
$query = "INSERT INTO members VALUES ('','{$username}','{$password}','{$firstName}','{$lastName}','{$emailAddress}','{$whoCreated}',{$whoUpdated}','{$whenUpdated}')";
mysql_query($query);
if (mysql_error())
echo mysql_error();

mysql_close();

}

}

where am I going wrong? Any help would be appreciated

[LordShryku]

What's the error message?

[byte_me]

Parse error: parse error in /..../..../..../..../formresult.php on line 4

I know it connects to the database as I tested that bit so that is OK.

[LordShryku]

put a ; on the end of this line

require_once ("/home/shopping/public_html/golf/connect.inc")

[byte_me]

Well that made the script run but no data!!!!!!

I obviously missed something.

I want to insert data into my DB

membershipSeq bigint(10) UNSIGNED No auto_increment

membershipID varchar(14) No NULL

username varchar(14) No NULL

password varchar(10) No NULL
firstName varchar(30) No NULL

lastName varchar(30) No NULL
emailAddress varchar(40) No NULL

joinDate date No 2004-01-01

active enum('n', 'y') No NULL y

disqualified enum('n', 'y') No NULL n

whoCreated varchar(30) No NULL

whoUpdated varchar(30) No NULL

whenUpdated timestamp(14) Yes NULL

can do it manually

have inserted 1 field

membershipSeq 1
membershipID admin1
username admin1
password rescue
firstName Ros
lastName McCabe
emailAddress [e-mail]
joinDate 2003-12-11
active y
disqualified y
whoCreated admin1
whoUpdated admin1
whenUpdated 20031211124735

Any ideas or is it back to the drawing board?????

[keith73]

echo $query to the browser before calling mysql_query to see what it looks like.

does mysql_error() return anything?

does your connect.inc file also call mysql_select_db() ?

• keith

[byte_me]

Hmm selecting the db would have been a good idea!!
Sorry I am a newbie at this php/MySQL stuff.

I get the error message now :

Column count doesn't match value count at row 1

Does this mean I have to have an exact data match to the table? Even if some of the fields are auto incremented or blank?

[aelma]

Print the values you are trying to save before insert into database.

echo $username
echo $password
.......

If doesn't return anything, then try with this:

In formresult.php:

mysql_query ("insert into members (field1,field2,field3) values ('$username','$password','$firstName','$lastName','$emailAddress')");

You no need a $HTTP_POST_VARS['username'];

You only have to use the value of the form as a variable.

That's all

Ana Elisa Martinez