where and how to use temparary tables?

[neenaprasad]

I have many rows in my table. I have to select id, first_name, last_name, introduced_by into a temporary table.all the members (names) in the table are not agents. In my table there another field named is_agent. If is_agent field is true that means he is an agent. In the introduced_by field agents_id occur more than once.i have to count the no of times agents_id occurs and display it in the temporary table. Can you help me?

[omerbutt]

I have many rows in my table. I have to select id, first_name, last_name, introduced_by into a temporary table.all the members (names) in the table are not agents. In my table there another field named is_agent. If is_agent field is true that means he is an agent. In the introduced_by field agents_id occur more than once.i have to count the no of times agents_id occurs and display it in the temporary table. Can you help me?

neena you have not explained our question properly its very precise you have to give the working code along with your question so that you could be quided properly otherwise you wont be getting a solution which would be very odd while remaining into this site cause this site has helped me throughout the projects and i have learned alot here really , em just a member like you , because you are a newbee thats why i dont want you be disappointed...[:)] ....take cares alot see ya around bubbai