linking tables from a database with PHP

Report · Sep 13, 2006

Good morning,

I wonder if anyone can help me with this. I am trying to use several tables from the same database in my query in PHP in Dreamweaver MX .

I have a results page on my website which contains :

artist name - Country
website
promo paragraph (etc....)

All show up fine and for "country" I get the respective numbers which are in that recordset and which refer to another table listing the Countries.

In the manual : "Dreamweaver MX dynamic applications" it tells you how to link those tables in ASP but not in PHP.
Can someone tell me how to do this please ?

Thanks
Chris

Report · Sep 13, 2006

linking tables is done in your SQL sentence, it doesn't matter if you're
using ASP, PHP, ...

try something like this (assuming tables are named ARTISTS & COUNTRIES):

"SELECT ARTISTS.NAME,ARTISTS.WEBSITE,...,COUNTRIES.COUNTRY
FROM ARTISTS
INNER JOIN COUNTRIES ON ARTISTS.COUNTRY = COUNTRIES.COUNTRY"

galorec wrote:
> Good morning,
>
> I wonder if anyone can help me with this. I am trying to use several tables
> from the same database in my query in PHP in Dreamweaver MX .
>
> I have a results page on my website which contains :
>
> artist name - Country
> website
> promo paragraph (etc....)
>
>
> All show up fine and for "country" I get the respective numbers which are in
> that recordset and which refer to another table listing the Countries.
>
> In the manual : "Dreamweaver MX dynamic applications" it tells you how to link
> those tables in ASP but not in PHP.
> Can someone tell me how to do this please ?
>
> Thanks
> Chris
>