Mysql problems

Bas Caminada <[email protected]>
Newsgroups gmane.comp.php.windows
Message-ID <[email protected]>
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)
?>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.