Copying field data from one table to a different one ....

[cesy]

Hi,
I made an extensive search on the board regarding this subject.
I found different solution but none of them worked for me.

I have a table named "pro_membersu_agents" that has about 20 fields but here are the ones that I need data transfered from :

fname, lname, phone, street, email, descr, url

So there are 7 fields.

In this table I have 4 users that are registered so there are 4 record sets.

########################################

In the same database, I have another table named "CRMcustomer" that has about 25 fields , but I only need the following fields to accept data from my first table:

custname, contact_title, contact_phone, contact_email, cust_address, cust_remarks, cust_homepage.

So there are fields too.

How can I transfer data from "fname' to "custname", from "lname' to "contact_title" ... etc .... ????

I have tried different INSERT/SELECT options as stated on this forum but none worked, the second database doesn't get populated.

I put the script in a php page, load it in IE, I don't get any parsing error, but the database is not getting populated.

Thank you, thank you for your assistance.

Luke

[bretticus]

INSERT INTO CRMcustomer (custname, contact_title, contact_phone, contact_email, cust_address, cust_remarks, cust_homepage) SELECT fname, lname, phone, street, email, descr, url FROM pro_membersu_agents

...doesn't work???

I'll assume you are doing this in MySQL as you never mentioned the database.

[cesy]

Thanks bretticus.
I can't explain. It works, I did the same thing before and it didn't work, I really don't know why.

Anyways, I would really appreciate if you could advise on how to check before for duplicate records. Because right now every time I execute the script, it adds the same records to the destination table.

So I want that BEFORE writing the records, it somehow just checks and eventually updates the table. I want the script to check if there's similar fname and lname, that's it, nothing more, emails can be the same.

Thanks a bunch,

Luke