Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is there a way to put
something in so mysql would tell me this - 2 hours pissing around for an
oversight.
TIA
----- Original Message -----
From: "C. Reeve" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 1:47 AM
Subject: Help, Insert not working.
Can anyone explain why this isn't working? It will not input the info into
the database.
$db = mysql_connect($serverhost, $serveruser, $serverpass);
mysql_select_db($database_name);
The variables in the above two rows are correct - I can do selects and it
works fine.
This is the data to be inserted and they are there....
echo "<BR>".$entered_email;
echo "<BR>".$entered_passwd;
echo "<BR>".$name;
Nothing happens.....
mysql_query ("INSERT INTO userdata (email, passwd, firstname, alias)
VALUES
('$entered_email','$entered_passwd','$name','Hello')");
TIA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]