var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Index on 2 different tables
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?
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().
Thanks for your reply and getting me started !!!
Here is what I have:
The field is Auto_Increment(ed) and I even tried:
INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES ( WHATHERE,'$subject', '$body')
but I get: Error adding entry: Duplicate entry '0' for key 1
INSERT INTO phpbb_posts_text (post_subject, post_text) VALUES ( '$subject', '$body')
Can anyone offer any help?
Based on that error message, methinks thou need'st mysqlcheck.