Thanks for your reply. It helped me a lot. But the reason for having separate tables is that I am building a membership directory. So i want to sort all data out.
I want to get the data from table 2 and 3 with the primary key of table 1.
Can you please help me out with this?
to be precise,
i have three tables.
table 1: has the user name and email
table 2: has user address and phone number
table 3: has other details.
So what i want to do is, when we click on the search results, i want the view page to show the output from all three tables. that is,
if the search result is,
name: xyz email: xyz@xyz.com
and when clicking on it, the output should be,
name: xyz
email: xyz2xyz.com
phone: blah blah
other details: blah blah
please help me on this
