[SOLVED] Problem Inserting Data into SQL Table

[Akenatehm]

Hey Guys,

 

I am trying to insert data into a MySQL table, it is showing one of the if error messages ("Could not insert comment")

 

Any help would be greatly appreciated.

 

Here is my code:

 

<?php

include "connect.php";

if(isset($_POST['submit']))

{

   $username=$_POST['username'];

   $password=$_POST['password'];
   
   $email=$_POST['email'];

   if(strlen($username)<1)

   {

      print "You did not enter a username.";

   }

   else if(strlen($password)<1)

   {

      print "You did not enter a password.";

   }

   else

   {

      $insert="Insert into users (username,password,email) values('$username','$password','$email')";

      mysql_query($insert) or die("Could not insert comment");
  
  print "Comment added. <A href='display.php'>Click here</a> to see all comments.";
   }

  }

?>

[samona]

what does the connect.php file look like?

[Akenatehm]

As far as I know it is connecting because it wasn't before and now it's not showing those errors. Anyway here it is:

 

<?PHP

$db = mysql_connect ("localhost", "username", "password");

if (!$db)

	die ("No Database Found");

if (!mysql_select_db ("kaurlcom_messenger",$db))

	die("No Database Selected");

?>

[samona]

Can you insert hte mysql_error() function into your program where you have the insert query and post the output.

 

  mysql_query($insert) or die("Could not insert comment" . mysql_error());

[Akenatehm]

Ok.

 

Could not insert commentUnknown column 'password' in 'field list'

[samona]

You have to type the column names in the program exactly as they are in the Table.  It is case sensitive.

[Akenatehm]

Omg such a stupid mistake, put password instead of pass. Ugh!

 

Thanks once again for all your help!

[samona]

my pleasure