(PHP/Mysql) Question reguarding tables and sharing data between.

[MephDaddy]

Ok here is my problem:

I have 2 tables, instance and boss

boss table has 3 varables [id, name, instid]
instance table has 2 variables [id, name]

in boss.instid is my way of pointing to instance.id

When displaying my information for the boss table I would like to show id, name, and instid.

But instead of just having a number that represents my instid i want it to take the name from instance table that is associated with that id.

I have searched thru endless tutorials on how to try and do this and have yet to find something that gives me a hint about how to do it. I might even be going about this the entirly wrong way.

I would appreciate any advise people can give me on this. I do I hope i made my idea clear.

[Taltos]

you need to do a sql query that looks something like this:

select boss.id, boss.name, instance.name
from boss
join instance
on boss.instid = instance.id

That should return what you are looking for and you can use php/mysql commands to read the data and do whatever you need to with it.

Good Luck

[MephDaddy]

I will give that a try thank you.

[ToddW]

If you index the join column it will go faster