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]
