1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
$requete=mysql_query("SELECT id,
date_entered,
date_modified,
modified_user_id,
created_by,
description,
deleted,
assigned_user_id,
salutation,
first_name,
last_name,
title,
department,
do_not_call,
phone_home,
phone_mobile,
phone_work,
phone_other,
phone_fax,
primary_address_street,
primary_address_city,
primary_address_state,
primary_address_postalcode,
primary_address_country,
alt_address_street,
alt_address_city,
alt_address_state,
alt_address_postalcode,
alt_address_country,
assistant,
assistant_phone,
reports_to_id,
portal_name,
portal_app,
campaign_id,
lead_source,
portal_name,
portal_active,
portal_app,
campaign_id FROM leads WHERE id='5c59aa34-eb22-04a5-b63c-4b0d3b269b6a' ");
while ($uneligne=mysql_fetch_array($requete))
{
mysql_query("INSERT INTO contacts (id,
date_entered,
date_modified,
modified_user_id,
created_by,
description,
deleted,
assigned_user_id,
salutation,
first_name,
last_name,
title,
department,
do_not_call,
phone_home,
phone_mobile,
phone_work,
phone_other,
phone_fax,
primary_address_street,
primary_address_city,
primary_address_state,
primary_address_postalcode,
primary_address_country,
alt_address_street,
alt_address_city,
alt_address_state,
alt_address_postalcode,
alt_address_country,
assistant,
assistant_phone,
reports_to_id,
portal_name,
portal_app,
campaign_id,
lead_source,
portal_name,
portal_active,
portal_app,
campaign_id) values (".$uneligne['id']." ,"$uneligne['date_entered'].", ".$uneligne['date_entered'].", ".$uneligne['date_modified'].", ".$uneligne['modified_user_id'].",
".$uneligne['created_by'].", ".$uneligne['description'].", ".$uneligne['deleted'].", ".$uneligne['assigner_user_id'].", ".$uneligne['salutation'].",
".$uneligne['first_name'].", ".$uneligne['last_name'].", ".$uneligne['title'].", ".$uneligne['department'].", ".$uneligne['do_not_call'].",
".$uneligne['phone_home'].", ".$uneligne['phone_mobile'].", ".$uneligne['phone_work'].", ".$uneligne['phone_other'].", ".$uneligne['phone_fax'].",
".$uneligne['primary_address_street'].", ".$uneligne['primary_address_city'].", ".$uneligne['primary_address_state'].", ".$uneligne['primary_address_postalcode'].",
".$uneligne['primary_address_country'].",".$uneligne['alt_address_street'].",
".$uneligne['alt_address_city'].",".$uneligne['alt_address_state'].",".$uneligne['alt_address_postalcode'].",".$uneligne['alt_address_country'].",
".$uneligne['assistant'].",".$uneligne['assistant_phone'].",".$uneligne['reports_to_id'].",".$uneligne['portal_name'].",".$uneligne['portal_app'].",
".$uneligne['campaign_id'].",".$uneligne['lead_source'].",".$uneligne['portal_name'].",".$uneligne['portal_active'].",".$uneligne['portal_app'].",".$uneligne['campaign_id']." ) ");
} |
