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

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

Code Review - SQL and Insertion Attacks (Warning: Not for Newbs)
Hey guys,

Its been a while, I know. Use to love coming here to answer peoples questions, but

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

DELETE FROM not working deletes wrong row
Hello

I have the following code which i found but it doesnt work properly.. it comes up with