I'm creating a table which extract 2 fields from another 2 tables. It's working well.
Whenever a new row inserted into the existing 2 tables it should be updated into the new table. How can I do it?
My create table code is:
Expand|Select|Wrap|Line Numbers
- create table exam(select a.username,b.qualification from users a, skill b where a.username=b.username);
For this i'm writing php script and my logic is,
i fetch the max(ID) from the skill table.
when the ID should be increased, then the new row will be inserted into exam table.
But My question is how do i know when the new row is inserted in the skill table or when will be the ID is increased?
Is my logic right? or any other ideas to do it?
Please show me the proper code.
Help me out......