I'm sorry I made a mistake here. You can't make double posts.
Jayme.
-----Mensagem Original-----
De: JJeffman <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sexta-feira, 16 de fevereiro de 2001 19:46
Assunto: Re: [PHP-DB] primary field
> No it hasn't. The field order in the form doesn't matter, but the order
you
> use their values in the query yes !
>
> I don't know what kind of operation you're making on the database
> updating, inserting, etc. ).
>
> If you are inserting you must not give any member_id, as long as it is
> generated by the database server. As you won't attribute any value to
> member_id you must tell which fields you are inserting : "insert into
table
> (last_name) values('$lastName')" this way you'll get no errors, at least
if
> last_name is not a unique key .
>
> If you is updating data you can't modify the member_id which is the table
> primary key.
>
> HTH.
>
> Jayme.
>
> -----Mensagem Original-----
> De: Marc Bragg <[EMAIL PROTECTED]>
> Para: <[EMAIL PROTECTED]>
> Enviada em: sexta-feira, 16 de fevereiro de 2001 17:55
> Assunto: [PHP-DB] primary field
>
>
> > Does the first field in a form have special significance?
> > Have two fields in table:
> >
> > last_name
> > member_id
> >
> > member_id is key and autoincrement.
> >
> > mysql won't accept two last names as same when last_name is first field.
> >
> > when member_id is made first field, then can input same last name into
> > last_name field.
> >
> > why is that?
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
