Displaying data from morethan 1 tables through php
I have two tables table1 and table2 in MySQL, in table1 i will be having fileds something like this

    create table table1(cid int(4) primary key, name varchar(15), email varchar(15), package int(15));

and in table to i will be having fields like this

  

     create table table2(id int(4), services_availed varchar(20), FOREIGN KEY cid REFERENCES table1)); 

in tabll2, in services_availed column, there will be morethan 10 services listed. 

Now, whenever user logins with his login credentials all the details of his should be displayed. How to do that. I am not getting any idea. I am using PHP

Please suggest me how to do it in php



Displaying data from morethan 1 tables through php
===

I have two tables table1 and table2 in MySQL, in table1 i will be having fileds something like this

    create table table1(cid int(4) primary key, name varchar(15), email varchar(15), package int(15));

and in table to i will be having fields like this

  

     create table table2(id int(4), services_availed varchar(20), FOREIGN KEY cid REFERENCES table1)); 

in tabll2, in services_availed column, there will be morethan 10 services listed. 

Now, whenever user logins with his login credentials all the details of his should be displayed. How to do that. I am not getting any idea. I am using PHP

Please suggest me how to do it in php


