[SOLVED] SQL?

[tom232]

I entered this code into mysql (phpmyadmin) [code]CREATE TABLE users (
userid INT unsigned NOT NULL AUTO_INCREMENT primary key,
username char(16) not null,
password char(10) not null,
email char (20) not null
);

[/code]

but in my php code [code]// if ok, put in db
  $result = mysql_query("insert into user values
                        ('$username', sha1('$password'), '$email')");
  if (!$result)
    throw new Exception(mysql_error);

  return true;
}[/code]

i am getting an error saying "mysql_error". help please ???

[craygo]

well you have 4 fields and only inserting 3 values it thinks you are trying to insert the username into the id field.

try
[code]// if ok, put in db
  $result = mysql_query("insert into user (username, password, email) values
                        ('$username', sha1('$password'), '$email')");
  if (!$result)
    throw new Exception(mysql_error);

  return true;
}[/code]

Ray

[ober]

[code]<?php
// if ok, put in db
 $result = mysql_query("insert into user values
                        ('$username', sha1('$password'), '$email')");
 if (!$result)
   throw new Exception(mysql_error());

 return true;
?>[/code]

mysql_error is a function.

[tom232]

haha ok