Re: [PHP-DB] primary field
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]
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-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]
