Would you care to elaborate on that - Using PHP there is no error or return
code - it just goes along happily saying the record was inserted. If there
is a way to do this, please explain.
TIA
----- Original Message -----
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "C. Reeve" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 9:32 AM
Subject: Re: Fw: Help, Insert not working.
> 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]
