Topic awaiting preservation: PHP/MySQL and editing PRIMARY

I have a PRIMARY KEY of "id" in my MySQL table which is smallINT(2), auto_increment, and NOT NULL.

My problem is being able to UPDATE the id through an HTML form processed under a looping PHP file. The form has the field type TEXT but when I SUBMIT, nothing happens if I've tried to edit the id. The other fields edit just fine though as they are set to VARCHAR(25), NULL, FullText. Any ideas on how I can allow for editing the id?

as far as Im aware, editing auto-incrementing ID's simply isn't possible

you might want to reconsider the use of an auto-incrementing field - it'll be a pain, but ultimately it'll make your system more flexible

I:.

I don't see why you couldn't change the auto_incremented field... and the manual doesn't say anything either.

Your problem might be that you're doing something like
"update table set id='$id', text = '$text'... where id='$id'
$id is the changed id that your form passes in.
You'd have to use the original id for the where clause to change the record. (put it in a hidden field on the form maybe.)

is that it?

See here also:
www.ozoneasylum.com/Forum12/HTML/001016.html

___________________
Emps

FAQs: Emperor

your problem is more likely with your primary key, primary key's must be unique attributes if you are trying to set a value in a colume set to primary to an existing value you are gonna be hosed.



.:[ Never resist a perfect moment ]:.