auto_increment???

arelgee

I have spent two days copying php code fragments using auto_increment but can't get them to work.
I learned SQL using Interbase and therein could be my problem. IB uses a generator to produce sequential fields. You write and seed the generator and call it whenever it is needed. At least, you used to back in the olden days.
All I want to do is add an ID to my stockpicking game. I want to set the initial number to 1001 so I can use the field as a string and it will always have the same number of chars (I may be wrong here but my understanding is there is no typing in php as in C++, so I can use an int as a string. Am I correct here or not???)
I want something like this:

create tabel stkpickr (ID int not null primary key auto_increment,
other things....._)
(another question, is the not null and primary key redundant or good insurance????)
Then I need the insert part

insert into stkpickr( ID, ...other things) values (what goes here???);

One good thing about this is that I have compiled an extensive code fragment library. I intend to edit it and make it available on my site. I have a section on starting your own business and the Internet is a mandatory addition to that.
arelgee at are-l-gee.com
TIA
PS I see php*****headpunk is gone. While I was posting to my thread about security this yoyo was spamming this site with graffiti. He got through the email validation on this site.

mikeatrpi

insert into stkpickr(other things) values (other things values);

You ignore the ID field on inserts and expect mysql to handle things by itself. There is a function to get the last inserted ID with php, but I can't remember what it is.

Now, you can do an insert into stkpickr with ID if you wish. MySQL's auto_increment feature simply finds the greatest integer and adds one. To get your 1000 base, insert the first row in the table with an ID of 1000. Then for every other insert leave out the ID field so that auto_increment will take over.

http://www.php.net/manual/en/language.types.type-juggling.php

arelgee

I thought that was the case, that you left the ID field blank on the insert.
But when I did so, the insert failed. When I put in the number, it worked.
I found some other bugs and fixed them and haven't tried since I fixed them all. I will try again.
I have already gotten up to 1003 on my ID field.
Just so I understand correctly. I should do this:

table stkpickr (ID int not null primary key auto_increment, etc,etc, etc) // 4 fields in table

insert into strpickr(etc,etc, etc, etc) values(etc, etc,etc) // 3 fields in insert statement

Talk about the eureka experience.................
I surmise that you leave off the ID in the first part.
I am used to using the APPEND records in C++ Builder and always put all fields in it. The not null primary key was the problem.
Thanx again for the help

mikeatrpi

insert into strpickr(etc,etc, etc, etc) values(etc, etc,etc)

Should be:
insert into strpickr(etc, etc, etc) values(etc, etc,etc)
always.

create TABLE stkpickr(
ID int not null primary key auto_increment, other int not null 
) 

insert into stkpickr(ID, other) values(1000,10);

insert into stkpickr(other) values(11);

insert into stkpickr(other) values(12);

SELECT * FROM stkpickr ORDER BY id asc;

Result:
ID      other  

1000 10 
1001 11 
1002 12