Index on 2 different tables

Eroc · #1 (**permalink**) 08-14-04, 15:32

I searched but I really don't know what I am searching for... but this is what I have...

I have two tables... 1 has an index the other doesn't...

when I insert into the one that has the index the index autoincrements... how do I grab that index number in the same insert (or not) so I can reference and insert it in the other table?

That make sense?

Thanks !
Eroc

Pat Phelan · #2 (**permalink**) 08-15-04, 09:52

If some of your code is providing the values, you'll have to retrieve those yourself. If MySQL is providing them using AUTO_INCREMENT, then you can retrieve the value using LAST_INSERT_ID().

-PatP

Eroc · #3 (**permalink**) 08-15-04, 10:10

Thanks for your reply and getting me started !!!

Here is what I have:

Code:

INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES ( WHATHERE,'$subject', '$body')

The field is Auto_Increment(ed) and I even tried:

Code:

INSERT INTO phpbb_posts_text (post_subject, post_text) VALUES ( '$subject', '$body')

but I get: Error adding entry: Duplicate entry '0' for key 1

Can anyone offer any help?

thanks,
Eroc

Pat Phelan · #4 (**permalink**) 08-16-04, 12:26

Based on that error message, methinks thou need'st mysqlcheck.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech