PHP : inserting row id to another table

Question

how can I get the row id of tbl_questions and send it to tbl_link_qa and then tbl_answers get to send it's row number to tbl_link_qa (same with tbl_questions) but this time it must correspond to the first row number from tbl_questions that was inserted first at tbl_link_qa

i need to link the row number of a question from tbl_questions and the row number of an answer from tbl_answers.

need help really bad

rec_id---qRec_id---aRec_id

96------------0-----------0

95------------0-----------0

I need to make it like this >>

rec_id---qRec_id----aRec_id

96----------123----------456

95----------124----------

123 and 124 is the row number from tbl_questions inserted into tbl_link_qa and 456 is from tbl_answers

Some database fields/tables/queries and code you have tried would help — Phill Pafford
– Phill Pafford, Commented Feb 9, 2011 at 14:04
You have written your question like an IM to a teenager: no capitalization, huge run-on sentences, no formatting. Andrew would like you to put more effort into asking your question if you want others to put effort into providing you with free work. — Dan Grossman
– Dan Grossman, Commented Feb 9, 2011 at 14:31

Dan Grossman · Accepted Answer · 2011-02-09 14:12:16Z

1

Use mysql_insert_id to get the auto_increment ID of the last row you inserted.

Ex:

mysql_query("INSERT INTO tbl_questions VALUES (something)");
$question_id = mysql_insert_id();

mysql_query("INSERT INTO tbl_answer VALUES (something)");
$answer_id = mysql_insert_id();

mysql_query("INSERT INTO tbl_link_qa (qRec_id, aRec_id) VALUES ($question_id, $answer_id)");

edited Feb 9, 2011 at 14:12

answered Feb 9, 2011 at 14:02

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

johanahChua Over a year ago

it's not exactly the last row inserted but more like the first row inserted.

Dan Grossman Over a year ago

"Last" means "most recent", as in "this is the identifier generated for the INSERT query you most recently ran on this connection". I have saved the ID of the row inserted into each table, what more are you asking for?

johanahChua Over a year ago

rec_id qRec_id aRec_id 96 0 0 95 0 0 this is what my tbl_link_qa looks like now, qRec_id comes from tbl_questions wherein it's the row number of the question submitted and aRec_id is the row number of the answer from tbl_answers.

Dan Grossman Over a year ago

My code gives you the ID of the row from tbl_questions and the ID of the row from tbl_answers... Then it puts them into your link table... Is there a reason you shared this schema with me? Was "question_id" instead of "qRec_id" confusing?

johanahChua Over a year ago

I guess so, I'm really pretty new in php. I'm not used to coding, I mostly and only do the designs since I do graphics so this is really a big challenge for me

|

Collectives™ on Stack Overflow

PHP : inserting row id to another table

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related