Mysql error message

Posted on 16th Feb 2014 07:03 pm by admin

help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'"

the sql for it is
Code: INSERT INTO accounts (firstname, lastname, username, password, joined, email, level) VALUES ('$_POST[fname]','$_POST[lname]','$_POST[user]',sha1('$_POST[pass]'),'$date','$_POST[email]','norm')";
$sqlcheck= mysql_query("SELECT * FROM accounts WHERE username = '$_POST[user]' OR email = '$_POST[email]'

Your Answer:

Login to answer

Other forums

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Getting number of affected rows in SQLPLUS..
Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving t

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft

PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie an

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

Retrieving innerHTML with cURL?
Hey all (sorry I know I'm a leecher, but I soon won't be. This is my first PHP project, but not my l