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)
?> 




Reply via email to