link tables

[Anon]

Can someone tell me how to display a table using a link table?

thank you.

[Anon]

What do you want to do?

[Anon]

Ok, I want to take the countryID from tblCountries and take the bandID from tblBands and display it a form so when a certain band name and info of the band shows up on the screen, the right country name shows up as well that the band belongs to. Bands and countries are related in a way that certain bands belong to certain countires and more than one band can be from the same country. I also have a link table with BandCountryID,BandID,CountryID. I know you have to compare these values with tblBands and tblCountries, but I just can't get it to work so when the band name or ID is selected, the right country shows displays. I am just learning PHP/MySql from last week. Your help would be appreciated.

-thanks,
novice

[Anon]

Read the mysql manual section about the JOIN statement, it does exactly what you want to do.

[Anon]

replace:
odbc_connect

with:
odbc_pconnect

This opens up a persistent connection:
http://localhost/phpmanual/function.odbc-pconnect.html