A somewhat complicated problem

Anon

The following code is supposed to grab the primary key from the last insert, and insert it into the table 'request'. It is grabbing some ID, but it is always one ahead. For example, if the last primary key was '1', it would show up as '2' in the request table...'2' would be '3', and so forth. How can I get the two to equal one another?

Thanx

$NewID=mysql_insert_id

$query="INSERT INTO request VALUES(NULL, NULL, '$request','$type',1,'$NewID')";
mysql_query($query) or DIE("Insert failed!");

toma42

You have to do an insert right before this.

$query 'insert into table (value) values ('string');

// Get the auto_incremented id from the value table for the last insert
$lastid mysql_insert_id();

If you are trying to use insert_id to get a sequence value, mysql doesn't support sequences but you can create a table to handle sequences.

Tom

toma42

Question magyartoth / Chris / Whoever.....

Why are using different aliases for your posts? Are you too lazy to use the manual and too proud to admit it?

What's the deal?

Anon

Ok, for a silly accusative question, I'll give a detailed, equally silly answer.

Magyartoth is the name I use for our intraoffice chat system. I sometimes use it on discussion boards too. Chris is the name I usually use when I'm at home and I also use it on Discussion boards(when using them from home). And sometimes I use Chriz(oh my!) when I'm using my laptop.

In short...I use whatever happens to already be on the form via cookies or whatever. There really is no other explaination although I'm sure you would like there to be.

George 🙂

Anon

Tom,

I don't think I'm trying to get a sequence value. 🙂 I just want to grab the unique ID of the last insert so I can then insert that as a foreign key into another table. (I know mysql doesn't really support FKs).

So in my code I do this:

$NewID=mysql_insert_id(); //get the last id

then...

$query="INSERT INTO request VALUES(NULL, NULL, '$request','$type',1,'$NewID')";

where the $NewID is the primary key of the last insert...

Does that make sense?

Im not sure why you have it like this:

$query 'insert into table (value) values ('string');

Why are you putting (value) right after table? I'm confuzed.

Thanks Tom! 🙂
chris

toma42

query 'insert into table (value) values ('string');
Why are you putting (value) right after table? I'm confuzed.

This was just example code. Correct syntax for an insert statement is
insert into table_name (column_name1, column_name2) values ('value1', 'value2');
but you can shorthand it to
insert into table_name values ('value1', 'value2');
if you only have the exact nubmer of columns in the table as you are supplying values for...but it's not a good idea to do this because if you add a column, you have to chagne all your code.

Anon

thanks tom, I'm slowly starting to come to grips over this problem. I think mysql_insert_id is working after all.