Jump to content


Photo

PHP and MySQL help


  • Please log in to reply
No replies to this topic

#1 Madatan

Madatan
  • Members
  • PipPipPip
  • Advanced Member
  • 51 posts

Posted 09 March 2006 - 11:06 AM

Okay so here is the scenario.

I've got two tables that I want to be connected(let's call the A and B), so I made a third table. In table A and B i got two primary keys a_id and b_id. Now I create the third table named AB. Inside that I create ab_id as primary and two foreign keys with the names a_id and b_id..... all is all good right now, working fine.

Now to the issue, what should I write in the code to get example ab_id 1 to show all it's information. And by all information I mean all the info that a_id and b_id have in their tables. You get what I'm looking for here?

Does this require some kind of JOIN?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users