Forum Moderators: coopster
I see the out put data not inserted?
<html>
<head>
<title> database</title>
</head>
<body>
<pre>
<?php
$connect=mysql_connect("localhost","root","*****");
mysql_select_db("mydatabase",$connect);
$insert_query="INSERT INTO users VALUES ('big','boy',
'big@monkees.com',PASSWORD('small'),NOW())";
if(mysql_query($insert_query,$connect))
print("data inserted");
else
print("data not inserted");
?>
</pre>
</body>
</html>
Try this code :
<?php
$connect=mysql_connect("localhost","root","*****");
mysql_select_db("mydatabase",$connect);
$insert_query="INSERT INTO users VALUES ('big','boy',
'big@monkees.com',PASSWORD('small'),NOW())";
$sql = mysql_query($insert_query) or die("SQL ERROR : ".mysql_error());
if($sql)
print("data inserted");
else
print("data not inserted");
?>
With that, if you've an error in mysql query, you'll see the error
SQL ERROR : Column count doesn't match value count at row 1
I have 5 columns
user_id,first_name,last_name,email,password,registration_date.
the user_id is MEDIUMINT NOT NULL AUTO_INCREMENT,
In my insert query I have tried
"INSERT INTO users VALUES (",'big','boy',
'big@monkees.com',PASSWORD('small'),NOW())";
but that doesn't work
please help...
but you're inserting 6
INSERT INTO users VALUES (", 'big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW())
and you say 6
user_id
first_name
last_name
email
password
registration_date
I would look at your table and see what's what
mysql is telling you, with that error, that the number of columns doesn't match
SHOW CREATE TABLE users;
The column headings are
user_id,first name,last name,email,password,registrationdate
user id: first name: last name: email: password registration date:
2 John Lennon john@beatles.com 734d56ec0089bb3a 2006-02-25 17:54:16
3 Paul McCartney paul@beatles.com 2c20438b7ed80185 2006-02-25 17:59:00
4 George Harrison george@authors.com 16b4c38141c119f9 2006-02-25 18:00:32
5 Ringo Starr ringo@beatles.com 49f6f01e5ab37a30 2006-02-26 17:05:10
6 David Jones davey@monkees.com 552151cf55e12624 2006-02-26 17:05:10
7 Peter Tork peter@monkees.com 7b48edff227042d5 2006-02-26 17:28:59
9 Mike Nesmith miky@monkees.com 7473f3886b36fdac 2006-02-26 17:38:50
10 David Sedaris david@authors.com 226ca5b57bc32575 2006-02-26 17:39:40
11 Nick Hornby nick@authors.com 62a21a7067a772ba 2006-02-26 17:40:32
12 Millesia Bank melly@monkees.com 3d91077c5470eef7 2006-02-26 17:41:27
13 Tony Morrrison tony@authors.com 789554fa2632d865 2006-02-26 17:42:16
[edited by: jatar_k at 10:22 pm (utc) on Feb. 27, 2006]
[edit reason] removed specifics [/edit]
specify the columns these values go into
INSERT INTO users (user_id, first_name, last_name, email, password, registration_date) VALUES (", 'big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW())
there are a couple different syntaxes for INSERT [dev.mysql.com]
INSERT INTO users(first_name,last_name,email,password,registration_date) VALUES ('big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW());
Normally, you shouldn't have any errors because I suppose the user_id is in auto-increment and primary key...
INSERT INTO users (user_id, first_name, last_name, email, password, registration_date) VALUES (", 'big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW())
It gave me the same error
but when I did
INSERT INTO users (user_id, first_name, last_name, email, password, registration_date) VALUES ('14', 'big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW())
row 14th was inserted.
ButI dont want to give a numerical value at user_id because that should come from AUT0_INCREMENT
Any clue?
Try it :
INSERT INTO users(first_name,last_name,email,password,registration_date) VALUES ('big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW());
INSERT INTO users(first_name,last_name,email,password,registration_date) VALUES ('big', 'boy', 'big@monkees.com', PASSWORD('small'), NOW());
