Getting Information Via Id

[arunpatal]

Hi,

 

Look this table

 

table 1

 

id int ai pkey

country v 75

 

 

table 2

 

id int ai pkey

name v 75

country int

 

 

My form is to add data on table 2 where name is text field and country is menu

which shows label as country and save its value as id from table 1.

 

now the added entry in my table 2 is like this

 

name and country id

 

now i want to make page where i can show the table 2 information but instead of

country id i want to show the name of country which is in table 1....

 

how can i do that ????????????

[thara]

here you need to use JOIN clause

 

try something like this....

 

SELECT name, country FROM table2
INNER JOIN table1 ON table1.countryId = table2.countryId

[arunpatal]

here you need to use JOIN clause

 

try something like this....

 

SELECT name, country FROM table2
INNER JOIN table1 ON table1.countryId = table2.countryId

 

Thanks

 

am testing............

 

will get back after test

[arunpatal]

Thanks

 

am testing............

 

will get back after test

 

merry christmas.........

 

it works