Mysql problems
| From: | Bas Caminada | Date: | Fri, 18 Mar 2011 06:37:13 +0000 |
| Subject: | Mysql problems | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-30533@lists.php.net to get a copy of this message | ||
Hi,
I am trying to build a CMS with info about clients, jobs in production etc etc.
Got the database running perfectly. Created tables for Contact details and i can enter and pull data
from the table.
How ever created a table to store usernames and passwords but when trying to INSERT INTO this table
i keep on getting
the error :
Error: Unknown column 'passwd' in 'field list'
I tried this first from the command line in mysql and retried this by creating and running 2 php
files, one to create the Table and the second to insert
data into it. But no luck.
Can anyone point me in the right directions, could this be a Mysql database problem.
Regards,
Bas
TABLE CREATION:
<?php
$con = mysql_connect("localhost","libra","visionairy");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("contacts", $con);
$sql='CREATE TABLE
members (
member_id int(11) unsigned NOT NULL AUTO_INCREMENT,
firstname varchar(100) default NULL,
lastname varchar(100) default NULL,
login varchar(100) NOT NULL default ",
passwd varchar(32) NOT NULL default ",
PRIMARY KEY (member_id)
) TYPE=MyISAM';
mysql_query ($sql,$con);
mysql_close($con)
?>
INSERT DATA INTO:
<?php
$con = mysql_connect("localhost","libra","visionairy");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("contacts", $con);
$sql="INSERT INTO members (member_id, firstname, lastname, login, passwd)
VALUES (1, Jatinder, Thind, phpsense,
ta018360fc26eodd2e929b8e77f052d)";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>