ProfileID

[MikeeX]

I am creating a address book application. Now I have a field in my table called "profileID". I want each entry to have an ID. So the first one added ID 1, second ID 2, and so on. Here is the link to my app

http://localrockstars.com/ab/

I enable Show_source() so you can see the code. If you notice view all you will see all the entries in there. All the ProfileID's are "0".

Anyway to make it grab a number on every add? Hope this makes sense.

Thanks for any information you can give me.

[rIkLuNd]

it's quite simple:

CREATE TABLE table(
id int not null auto_increment,
primary key(id)...

// and so on...

[atomm]

Make sure your id field is set to be the primary key of the table, and has the AUTO_INCREMENT flag. That way each new row added will have a unique ID.

[DeadlySin3]

If you dont have your mind made up to build your own address book, I know of a pretty killer one already : Well, its a phone book, but changing it to fit your needs wouldn't be much trouble at all..

[ Flat File Database ]

in the sample code provided w/the FFDB library, a phone book already exists - just play around w/it for a while, you'll get the hang of it 😉

[MikeeX]

Wow, thats easy enough guys. Thanks for your help.