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]

Reply via email to