mySQL, PHP

Quote:

---

Originally Posted by Twey

Evidently... you want to find a certain field, then, based on that field, display data from a row in another table that also contains the data in that field?

---

Woo, confusing, but yes, i think thats right!!

Let me explain again just to clarify...

Content in the main table:
aaa bbb ccc ddd eee fff

I want to see if these are available in the other tables (categories). If they are available echo:

aaa found in cat1|aaa found in cat2 etc...

Ok, maybe this will better explain...
The main table (tbmain) has a list of all the mobile phones on my datababse.
Nokia n71 | Nokia N90 | Bla Bla | Bla

The other tables are a list of phones on a network, e.g. vodafone, tmobile, orange, o2, virgin, btmobile, three

I want to see what handsets (from tbmain) are available on each network, and "echo" it on the page.

So, (for e.g.) the Nokia n71 is available on btmobile and virgin, so i want this to happen:

Nokia N71 on btmobile | Nokia N71 on Virgin

Then i want the script to go through all the handsets from tbmain, so i would get a list of all the handsets, still showing wha network the handset is on:

Nokia N71 on btmobile | Nokia N71 on Virgin |
Nokia N90 on orange | Nokia N90 on Virgin | Nokia N90 on o2 |
Bla Bla on orange |
Bla on vodafone | Bla on three |

Does that clear things up Twey?