Warning: include(../header.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 2
Warning: include(../header.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 2
Warning: include() [function.include]: Failed opening '../header.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 2
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 3
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 4
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 32
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 33
43957.7316782
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 70
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 71
Deal 43957.73167821.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 95
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 96
Email Added harpreet.vigg@gmail.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 108
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 109
43957.7316782
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 146
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 147
Deal 43957.73167821.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 171
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 172
Email Added harpreet.vigg@gmail.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 184
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 185
43957.7316782
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 222
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 223
Deal 43957.73167821.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 247
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 248
Email Added harpreet.vigg@gmail.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 260
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 261
44018.890767
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 298
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 299
Deal 44018.89076697.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 323
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 324
Email Added rjshahir@yahoo.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 336
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 337
44018.890767
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 374
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 375
Deal 43590.54253214.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 399
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 400
Email Added merysaeed@yahoo.co.uk.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 412
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 413
43592.5598231
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 450
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 451
Deal 43592.55982310.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 475
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 476
Email Added bedi.gk79@gmail.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 488
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 489
43592.5598231
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 526
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 527
Deal 43592.55982310.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 551
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 552
Email Added bedi.gk79@gmail.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 564
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 565
43598.6644783
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 600
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 601
Deal 43598.66447833.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 625
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 626
Email Added nimesh147@yahoo.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 638
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 639
44018.9236871
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 676
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 677
Deal 44018.92368714.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 701
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 702
Email Added nimesh147@yahoo.com.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 714
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 715
44018.9236871
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 752
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 753
Deal 44018.92368714.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 777
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 778
Email Added nimesh147@yahoo.com.
Warning: include(../CMSheaderPointer.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 809
Warning: include(../CMSheaderPointer.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 809
Warning: include() [function.include]: Failed opening '../CMSheaderPointer.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 809
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 817
RAMESHWAR',
'SANTLAL',
'naradramcharan@gmail.com',
'6475625254',
'6479755232',
'',
'2 DENLOW DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y2L4',
'2019/05/23',
'07:23:03',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43608.80767844';
}
else {$sql="update tb_Prospect set
col_LastName='RAMESHWAR',
col_FirstName='SANTLAL'
where col_ID ='43608.80767844'";
$SQLMessage = '43608.80767844';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='naradramcharan@gmail.com',
col_PhoneRes='6475625254',
col_PhoneBus='6479755232',
col_Cell1='',
col_Address='2 DENLOW DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y2L4'
where col_ID ='43608.80767844' and col_address= '' or col_Address is null";
$SQLMessage = 'naradramcharan@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43869.58685795'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43869.58685795;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43869.58685795', 'SINGH BUTTAR',
'NIRMAL',
'nirmalbuttar0@gmail.com',
'9562824225',
'6475055371',
'',
'290 EDENBROOK HILL DR',
'',
'BRAMPTON',
'ONTARIO',
'L7A2M5',
'2020/02/08',
'02:05:05',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43869.58685795';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH BUTTAR',
col_FirstName='NIRMAL'
where col_ID ='43869.58685795'";
$SQLMessage = '43869.58685795';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='nirmalbuttar0@gmail.com',
col_PhoneRes='9562824225',
col_PhoneBus='6475055371',
col_Cell1='',
col_Address='290 EDENBROOK HILL DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A2M5'
where col_ID ='43869.58685795' and col_address= '' or col_Address is null";
$SQLMessage = 'nirmalbuttar0@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43869.72769370'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43869.72769370;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43869.72769370', 'PATEL',
'BRIJ',
'drbrijpatelod@gmail.com',
'5196974656',
'',
'',
'208 CEDARVALE CRES',
'',
'WATERLOO',
'ONTARIO',
'',
'2020/02/08',
'05:27:53',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43869.72769370';
}
else {$sql="update tb_Prospect set
col_LastName='PATEL',
col_FirstName='BRIJ'
where col_ID ='43869.72769370'";
$SQLMessage = '43869.72769370';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='drbrijpatelod@gmail.com',
col_PhoneRes='5196974656',
col_PhoneBus='',
col_Cell1='',
col_Address='208 CEDARVALE CRES',
col_Apartment='',
col_City='WATERLOO',
col_Province='ONTARIO',
col_PostalCode=''
where col_ID ='43869.72769370' and col_address= '' or col_Address is null";
$SQLMessage = 'drbrijpatelod@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43869.72769370'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43869.72769370;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43869.72769370', 'PATEL',
'BRIJ',
'drbrijpatelod@gmail.com',
'5196974656',
'',
'',
'208 CEDARVALE CRES',
'',
'WATERLOO',
'ONTARIO',
'',
'2020/02/08',
'05:27:53',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43869.72769370';
}
else {$sql="update tb_Prospect set
col_LastName='PATEL',
col_FirstName='BRIJ'
where col_ID ='43869.72769370'";
$SQLMessage = '43869.72769370';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='drbrijpatelod@gmail.com',
col_PhoneRes='5196974656',
col_PhoneBus='',
col_Cell1='',
col_Address='208 CEDARVALE CRES',
col_Apartment='',
col_City='WATERLOO',
col_Province='ONTARIO',
col_PostalCode=''
where col_ID ='43869.72769370' and col_address= '' or col_Address is null";
$SQLMessage = 'drbrijpatelod@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43872.67990940'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43872.67990940;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43872.67990940', 'KAUR KHAIRA',
'RAJPAL',
'harminderkhaira@hotmail.com',
'6474099332',
'6474644393',
'',
'26 VALLEY PARK CRES',
'',
'BRAMPTON',
'ONTARIO',
'L7A 1X9',
'2020/02/11',
'04:19:04',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43872.67990940';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR KHAIRA',
col_FirstName='RAJPAL'
where col_ID ='43872.67990940'";
$SQLMessage = '43872.67990940';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harminderkhaira@hotmail.com',
col_PhoneRes='6474099332',
col_PhoneBus='6474644393',
col_Cell1='',
col_Address='26 VALLEY PARK CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A 1X9'
where col_ID ='43872.67990940' and col_address= '' or col_Address is null";
$SQLMessage = 'harminderkhaira@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43872.67990940'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43872.67990940;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43872.67990940', 'KAUR KHAIRA',
'RAJPAL',
'harminderkhaira@hotmail.com',
'6474099332',
'6474644393',
'',
'26 VALLEY PARK CRES',
'',
'BRAMPTON',
'ONTARIO',
'L7A 1X9',
'2020/02/11',
'04:19:04',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43872.67990940';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR KHAIRA',
col_FirstName='RAJPAL'
where col_ID ='43872.67990940'";
$SQLMessage = '43872.67990940';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harminderkhaira@hotmail.com',
col_PhoneRes='6474099332',
col_PhoneBus='6474644393',
col_Cell1='',
col_Address='26 VALLEY PARK CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A 1X9'
where col_ID ='43872.67990940' and col_address= '' or col_Address is null";
$SQLMessage = 'harminderkhaira@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43873.83126362'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43873.83126362;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43873.83126362', 'KHAN',
'FAISAL',
'faisalkhan10@gmail.com',
'4166021510',
'',
'',
'26 WOODSEND RUN',
'',
'BRAMPTON',
'ONTARIO',
'L6Y4G8',
'2020/02/12',
'07:57:01',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43873.83126362';
}
else {$sql="update tb_Prospect set
col_LastName='KHAN',
col_FirstName='FAISAL'
where col_ID ='43873.83126362'";
$SQLMessage = '43873.83126362';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='faisalkhan10@gmail.com',
col_PhoneRes='4166021510',
col_PhoneBus='',
col_Cell1='',
col_Address='26 WOODSEND RUN',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y4G8'
where col_ID ='43873.83126362' and col_address= '' or col_Address is null";
$SQLMessage = 'faisalkhan10@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43881.70722811'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43881.70722811;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43881.70722811', 'SINGH SAINI',
'JOGINDER',
'SAINIGAGAN@LIVE.COM',
'6477464404',
'',
'',
'52 LOCKBURN CRES',
'',
'BRAMPTON',
'ONTARIO',
'L7A 3W8',
'2020/02/20',
'04:58:25',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43881.70722811';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH SAINI',
col_FirstName='JOGINDER'
where col_ID ='43881.70722811'";
$SQLMessage = '43881.70722811';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='SAINIGAGAN@LIVE.COM',
col_PhoneRes='6477464404',
col_PhoneBus='',
col_Cell1='',
col_Address='52 LOCKBURN CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A 3W8'
where col_ID ='43881.70722811' and col_address= '' or col_Address is null";
$SQLMessage = 'SAINIGAGAN@LIVE.COM';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43883.50522892'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43883.50522892;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43883.50522892', 'MANDER',
'HARSHDEEP',
'harsh.feb12@yahoo.ca',
'6472427389',
'6477393827',
'',
'28 GILLIS RD',
'',
'BRAMPTON',
'ONTARIO',
'L7A4V6',
'2020/02/22',
'12:07:32',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43883.50522892';
}
else {$sql="update tb_Prospect set
col_LastName='MANDER',
col_FirstName='HARSHDEEP'
where col_ID ='43883.50522892'";
$SQLMessage = '43883.50522892';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harsh.feb12@yahoo.ca',
col_PhoneRes='6472427389',
col_PhoneBus='6477393827',
col_Cell1='',
col_Address='28 GILLIS RD',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A4V6'
where col_ID ='43883.50522892' and col_address= '' or col_Address is null";
$SQLMessage = 'harsh.feb12@yahoo.ca';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43883.68192717'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43883.68192717;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43883.68192717', 'KAUR NAHAR',
'SURINDER',
'surindergill28@yahoo.ca',
'4162066868',
'4372160011',
'',
'582 REMEMBERANCE RD',
'',
'',
'',
'L7A4N2',
'2020/02/22',
'04:21:59',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43883.68192717';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR NAHAR',
col_FirstName='SURINDER'
where col_ID ='43883.68192717'";
$SQLMessage = '43883.68192717';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='surindergill28@yahoo.ca',
col_PhoneRes='4162066868',
col_PhoneBus='4372160011',
col_Cell1='',
col_Address='582 REMEMBERANCE RD',
col_Apartment='',
col_City='',
col_Province='',
col_PostalCode='L7A4N2'
where col_ID ='43883.68192717' and col_address= '' or col_Address is null";
$SQLMessage = 'surindergill28@yahoo.ca';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43884.70653050'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43884.70653050;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43884.70653050', 'DHAMIJA',
'SUDEEP',
'sudeep05@gmailcom',
'6475308944',
'',
'',
'22 LOCOMOTIVE CRES',
'',
'BRAMPTON',
'ONTARIO',
'L7A0T7',
'2020/02/23',
'04:57:24',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43884.70653050';
}
else {$sql="update tb_Prospect set
col_LastName='DHAMIJA',
col_FirstName='SUDEEP'
where col_ID ='43884.70653050'";
$SQLMessage = '43884.70653050';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='sudeep05@gmailcom',
col_PhoneRes='6475308944',
col_PhoneBus='',
col_Cell1='',
col_Address='22 LOCOMOTIVE CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A0T7'
where col_ID ='43884.70653050' and col_address= '' or col_Address is null";
$SQLMessage = 'sudeep05@gmailcom';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43884.82570621'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43884.82570621;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43884.82570621', 'SANATAN RAMJAATTAN',
'LOKESHWAR',
'nathanramjattan@gmail.com',
'6479263082',
'6479849021',
'',
'102 LOLA CRES',
'',
'BRAMPTON',
'ONTARIO',
'L7A4J7',
'2020/02/23',
'07:49:01',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43884.82570621';
}
else {$sql="update tb_Prospect set
col_LastName='SANATAN RAMJAATTAN',
col_FirstName='LOKESHWAR'
where col_ID ='43884.82570621'";
$SQLMessage = '43884.82570621';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='nathanramjattan@gmail.com',
col_PhoneRes='6479263082',
col_PhoneBus='6479849021',
col_Cell1='',
col_Address='102 LOLA CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A4J7'
where col_ID ='43884.82570621' and col_address= '' or col_Address is null";
$SQLMessage = 'nathanramjattan@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43885.71220806'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43885.71220806;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43885.71220806', 'LE',
'THUC',
'cuongandhua@hotmail.com',
'6476866234',
'',
'',
'32 MARY CHAPMAN BLVD ',
'',
'TORONTO',
'ONTARIO',
'M9M0B2',
'2020/02/24',
'05:05:35',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43885.71220806';
}
else {$sql="update tb_Prospect set
col_LastName='LE',
col_FirstName='THUC'
where col_ID ='43885.71220806'";
$SQLMessage = '43885.71220806';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='cuongandhua@hotmail.com',
col_PhoneRes='6476866234',
col_PhoneBus='',
col_Cell1='',
col_Address='32 MARY CHAPMAN BLVD ',
col_Apartment='',
col_City='TORONTO',
col_Province='ONTARIO',
col_PostalCode='M9M0B2'
where col_ID ='43885.71220806' and col_address= '' or col_Address is null";
$SQLMessage = 'cuongandhua@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43885.71220806'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43885.71220806;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43885.71220806', 'LE',
'THUC',
'cuongandhua@hotmail.com',
'6476866234',
'',
'',
'32 MARY CHAPMAN BLVD ',
'',
'TORONTO',
'ONTARIO',
'M9M0B2',
'2020/02/24',
'05:05:35',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43885.71220806';
}
else {$sql="update tb_Prospect set
col_LastName='LE',
col_FirstName='THUC'
where col_ID ='43885.71220806'";
$SQLMessage = '43885.71220806';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='cuongandhua@hotmail.com',
col_PhoneRes='6476866234',
col_PhoneBus='',
col_Cell1='',
col_Address='32 MARY CHAPMAN BLVD ',
col_Apartment='',
col_City='TORONTO',
col_Province='ONTARIO',
col_PostalCode='M9M0B2'
where col_ID ='43885.71220806' and col_address= '' or col_Address is null";
$SQLMessage = 'cuongandhua@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43885.71220806'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43885.71220806;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43885.71220806', 'LE',
'THUC',
'cuongandhua@hotmail.com',
'6476866234',
'',
'',
'32 MARY CHAPMAN BLVD ',
'',
'TORONTO',
'ONTARIO',
'M9M0B2',
'2020/02/24',
'05:05:35',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43885.71220806';
}
else {$sql="update tb_Prospect set
col_LastName='LE',
col_FirstName='THUC'
where col_ID ='43885.71220806'";
$SQLMessage = '43885.71220806';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='cuongandhua@hotmail.com',
col_PhoneRes='6476866234',
col_PhoneBus='',
col_Cell1='',
col_Address='32 MARY CHAPMAN BLVD ',
col_Apartment='',
col_City='TORONTO',
col_Province='ONTARIO',
col_PostalCode='M9M0B2'
where col_ID ='43885.71220806' and col_address= '' or col_Address is null";
$SQLMessage = 'cuongandhua@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43890.65839049'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43890.65839049;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43890.65839049', 'ANN ALTHEA SAMUELS',
'STACY',
'uniquewow1s@yahoo.com',
'3473881051',
'6479189996',
'',
'16 KINCAID CRT ',
'',
'BRAMPTON',
'ONTARIO',
'L6Z 1E4',
'2020/02/29',
'03:48:05',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43890.65839049';
}
else {$sql="update tb_Prospect set
col_LastName='ANN ALTHEA SAMUELS',
col_FirstName='STACY'
where col_ID ='43890.65839049'";
$SQLMessage = '43890.65839049';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='uniquewow1s@yahoo.com',
col_PhoneRes='3473881051',
col_PhoneBus='6479189996',
col_Cell1='',
col_Address='16 KINCAID CRT ',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Z 1E4'
where col_ID ='43890.65839049' and col_address= '' or col_Address is null";
$SQLMessage = 'uniquewow1s@yahoo.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43891.48974481'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43891.48974481;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43891.48974481', 'CHANMUGANATHAN',
'CHUTHAGARAN',
'sutha849@gmail.com',
'4168446084',
'9057559801',
'',
'849 PRESTON MANOR DR',
'',
'MISSISSAUGA',
'ONTARIO',
'L5V2L7',
'2020/03/01',
'11:45:14',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43891.48974481';
}
else {$sql="update tb_Prospect set
col_LastName='CHANMUGANATHAN',
col_FirstName='CHUTHAGARAN'
where col_ID ='43891.48974481'";
$SQLMessage = '43891.48974481';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='sutha849@gmail.com',
col_PhoneRes='4168446084',
col_PhoneBus='9057559801',
col_Cell1='',
col_Address='849 PRESTON MANOR DR',
col_Apartment='',
col_City='MISSISSAUGA',
col_Province='ONTARIO',
col_PostalCode='L5V2L7'
where col_ID ='43891.48974481' and col_address= '' or col_Address is null";
$SQLMessage = 'sutha849@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43891.52255098'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43891.52255098;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43891.52255098', 'NELAPALTA',
'NARESH',
'nareshnelapatla@gmail.com',
'6478685687',
'2263363137',
'',
'138 PEACH BLOSSOM CRES',
'',
'BRAMPTON',
'ONTARIO',
'N2E3Z7',
'2020/03/01',
'12:32:28',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43891.52255098';
}
else {$sql="update tb_Prospect set
col_LastName='NELAPALTA',
col_FirstName='NARESH'
where col_ID ='43891.52255098'";
$SQLMessage = '43891.52255098';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='nareshnelapatla@gmail.com',
col_PhoneRes='6478685687',
col_PhoneBus='2263363137',
col_Cell1='',
col_Address='138 PEACH BLOSSOM CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='N2E3Z7'
where col_ID ='43891.52255098' and col_address= '' or col_Address is null";
$SQLMessage = 'nareshnelapatla@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43906.67590444'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43906.67590444;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43906.67590444', 'SINGH',
'JARNAIL',
'jarnail@live.in',
'4372446424',
'',
'',
'16 TRIPLE CROWN DR',
'',
'BRAMPTON',
'ONTARIO',
'L6S0B1',
'2020/03/16',
'04:13:18',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43906.67590444';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH',
col_FirstName='JARNAIL'
where col_ID ='43906.67590444'";
$SQLMessage = '43906.67590444';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='jarnail@live.in',
col_PhoneRes='4372446424',
col_PhoneBus='',
col_Cell1='',
col_Address='16 TRIPLE CROWN DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6S0B1'
where col_ID ='43906.67590444' and col_address= '' or col_Address is null";
$SQLMessage = 'jarnail@live.in';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43906.67590444'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43906.67590444;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43906.67590444', 'SINGH',
'JARNAIL',
'jarnail@live.in',
'4372446424',
'',
'',
'16 TRIPLE CROWN DR',
'',
'BRAMPTON',
'ONTARIO',
'L6S0B1',
'2020/03/16',
'04:13:18',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43906.67590444';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH',
col_FirstName='JARNAIL'
where col_ID ='43906.67590444'";
$SQLMessage = '43906.67590444';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='jarnail@live.in',
col_PhoneRes='4372446424',
col_PhoneBus='',
col_Cell1='',
col_Address='16 TRIPLE CROWN DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6S0B1'
where col_ID ='43906.67590444' and col_address= '' or col_Address is null";
$SQLMessage = 'jarnail@live.in';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43995.51171192'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43995.51171192;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43995.51171192', 'BHAGWATIPRASAD BAHUGUNA',
'ASHISH',
'ashish_bahuguna@hotmail.com',
'6478195337',
'6476155337',
'',
'2-148 INSPIRE BLVD',
'',
'BRAMPTON',
'ONTARIO',
'L6R3X7',
'2020/06/13',
'12:16:52',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43995.51171192';
}
else {$sql="update tb_Prospect set
col_LastName='BHAGWATIPRASAD BAHUGUNA',
col_FirstName='ASHISH'
where col_ID ='43995.51171192'";
$SQLMessage = '43995.51171192';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='ashish_bahuguna@hotmail.com',
col_PhoneRes='6478195337',
col_PhoneBus='6476155337',
col_Cell1='',
col_Address='2-148 INSPIRE BLVD',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6R3X7'
where col_ID ='43995.51171192' and col_address= '' or col_Address is null";
$SQLMessage = 'ashish_bahuguna@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '43996.56628259'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 43996.56628259;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '43996.56628259', 'PURI',
'RACHNA',
'rachnapuri82@gmail.com',
'4379896481',
'4379822509',
'',
'1803-50 FOREST MANOR RD',
'',
'TORONTO',
'ONTARIO',
'M2J0E3',
'2020/06/14',
'01:35:27',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '43996.56628259';
}
else {$sql="update tb_Prospect set
col_LastName='PURI',
col_FirstName='RACHNA'
where col_ID ='43996.56628259'";
$SQLMessage = '43996.56628259';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='rachnapuri82@gmail.com',
col_PhoneRes='4379896481',
col_PhoneBus='4379822509',
col_Cell1='',
col_Address='1803-50 FOREST MANOR RD',
col_Apartment='',
col_City='TORONTO',
col_Province='ONTARIO',
col_PostalCode='M2J0E3'
where col_ID ='43996.56628259' and col_address= '' or col_Address is null";
$SQLMessage = 'rachnapuri82@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44009.59644302'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44009.59644302;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44009.59644302', 'SINGH MANSHAHIA',
'MANPREET',
'manprit419@gmail.com',
'6472331039',
'4372164900',
'',
'15 ATTRACTION DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y2Z8',
'2020/06/27',
'02:18:53',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44009.59644302';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH MANSHAHIA',
col_FirstName='MANPREET'
where col_ID ='44009.59644302'";
$SQLMessage = '44009.59644302';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='manprit419@gmail.com',
col_PhoneRes='6472331039',
col_PhoneBus='4372164900',
col_Cell1='',
col_Address='15 ATTRACTION DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y2Z8'
where col_ID ='44009.59644302' and col_address= '' or col_Address is null";
$SQLMessage = 'manprit419@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44009.59644302'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44009.59644302;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44009.59644302', 'SINGH MANSHAHIA',
'MANPREET',
'manprit419@gmail.com',
'6472331039',
'4372164900',
'',
'15 ATTRACTION DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y2Z8',
'2020/06/27',
'02:18:53',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44009.59644302';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH MANSHAHIA',
col_FirstName='MANPREET'
where col_ID ='44009.59644302'";
$SQLMessage = '44009.59644302';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='manprit419@gmail.com',
col_PhoneRes='6472331039',
col_PhoneBus='4372164900',
col_Cell1='',
col_Address='15 ATTRACTION DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y2Z8'
where col_ID ='44009.59644302' and col_address= '' or col_Address is null";
$SQLMessage = 'manprit419@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44009.62280930'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44009.62280930;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44009.62280930', 'REGAN THOMAS',
'RONALD',
't.regan27@gmail.com',
'6472090552',
'4167797433',
'',
'15 STAGE MEADOW CRES',
'',
'BRAMPTON',
'ONTARIO',
'L6Y0Y1',
'2020/06/27',
'02:56:51',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44009.62280930';
}
else {$sql="update tb_Prospect set
col_LastName='REGAN THOMAS',
col_FirstName='RONALD'
where col_ID ='44009.62280930'";
$SQLMessage = '44009.62280930';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='t.regan27@gmail.com',
col_PhoneRes='6472090552',
col_PhoneBus='4167797433',
col_Cell1='',
col_Address='15 STAGE MEADOW CRES',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y0Y1'
where col_ID ='44009.62280930' and col_address= '' or col_Address is null";
$SQLMessage = 't.regan27@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44011.74833829'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44011.74833829;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44011.74833829', 'SHARMA',
'BHUPESH',
'bsharmarealtor@gmail.com',
'6476784658',
'9059132551',
'',
'70 LEPARC RD',
'',
'BRAMPTON',
'ONTARIO',
'L6P2K6',
'2020/06/29',
'05:57:36',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44011.74833829';
}
else {$sql="update tb_Prospect set
col_LastName='SHARMA',
col_FirstName='BHUPESH'
where col_ID ='44011.74833829'";
$SQLMessage = '44011.74833829';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='bsharmarealtor@gmail.com',
col_PhoneRes='6476784658',
col_PhoneBus='9059132551',
col_Cell1='',
col_Address='70 LEPARC RD',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6P2K6'
where col_ID ='44011.74833829' and col_address= '' or col_Address is null";
$SQLMessage = 'bsharmarealtor@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44016.57015870'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44016.57015870;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44016.57015870', 'ASHWIN RAJKUMAR',
'DHEERAJ',
'jigna6@yahoo.com',
'6476384530',
'4166609788',
'',
'7369 LANTERN FLY HOLLOW ',
'',
'MISSISSAUGA',
'ONTARIO',
'L5W1J8',
'2020/07/04',
'01:41:02',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44016.57015870';
}
else {$sql="update tb_Prospect set
col_LastName='ASHWIN RAJKUMAR',
col_FirstName='DHEERAJ'
where col_ID ='44016.57015870'";
$SQLMessage = '44016.57015870';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='jigna6@yahoo.com',
col_PhoneRes='6476384530',
col_PhoneBus='4166609788',
col_Cell1='',
col_Address='7369 LANTERN FLY HOLLOW ',
col_Apartment='',
col_City='MISSISSAUGA',
col_Province='ONTARIO',
col_PostalCode='L5W1J8'
where col_ID ='44016.57015870' and col_address= '' or col_Address is null";
$SQLMessage = 'jigna6@yahoo.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44016.57015870'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44016.57015870;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44016.57015870', 'ASHWIN RAJKUMAR',
'DHEERAJ',
'jigna6@yahoo.com',
'6476384530',
'4166609788',
'',
'7369 LANTERN FLY HOLLOW ',
'',
'MISSISSAUGA',
'ONTARIO',
'L5W1J8',
'2020/07/04',
'01:41:02',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44016.57015870';
}
else {$sql="update tb_Prospect set
col_LastName='ASHWIN RAJKUMAR',
col_FirstName='DHEERAJ'
where col_ID ='44016.57015870'";
$SQLMessage = '44016.57015870';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='jigna6@yahoo.com',
col_PhoneRes='6476384530',
col_PhoneBus='4166609788',
col_Cell1='',
col_Address='7369 LANTERN FLY HOLLOW ',
col_Apartment='',
col_City='MISSISSAUGA',
col_Province='ONTARIO',
col_PostalCode='L5W1J8'
where col_ID ='44016.57015870' and col_address= '' or col_Address is null";
$SQLMessage = 'jigna6@yahoo.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44016.61104915'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44016.61104915;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44016.61104915', 'S PANNU',
'JASDIL',
'kabir.1980@hotmail.com',
'6478328183',
'4169064020',
'',
'33 CUSTOMLINE DR',
'',
'BRAMPTON',
'ONTARIO',
'L7A1J3',
'2020/07/04',
'02:39:55',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44016.61104915';
}
else {$sql="update tb_Prospect set
col_LastName='S PANNU',
col_FirstName='JASDIL'
where col_ID ='44016.61104915'";
$SQLMessage = '44016.61104915';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='kabir.1980@hotmail.com',
col_PhoneRes='6478328183',
col_PhoneBus='4169064020',
col_Cell1='',
col_Address='33 CUSTOMLINE DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A1J3'
where col_ID ='44016.61104915' and col_address= '' or col_Address is null";
$SQLMessage = 'kabir.1980@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44016.61104915'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44016.61104915;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44016.61104915', 'S PANNU',
'JASDIL',
'kabir.1980@hotmail.com',
'6478328183',
'4169064020',
'',
'33 CUSTOMLINE DR',
'',
'BRAMPTON',
'ONTARIO',
'L7A1J3',
'2020/07/04',
'02:39:55',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44016.61104915';
}
else {$sql="update tb_Prospect set
col_LastName='S PANNU',
col_FirstName='JASDIL'
where col_ID ='44016.61104915'";
$SQLMessage = '44016.61104915';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='kabir.1980@hotmail.com',
col_PhoneRes='6478328183',
col_PhoneBus='4169064020',
col_Cell1='',
col_Address='33 CUSTOMLINE DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A1J3'
where col_ID ='44016.61104915' and col_address= '' or col_Address is null";
$SQLMessage = 'kabir.1980@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.60722320'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.60722320;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.60722320', 'A MISTRY',
'DIXITKUMAR',
'dixitkumarmistry@gmail.com',
'4164172991',
'6477023157',
'',
'4 PAPE DR',
'',
'BRAMPTON',
'ONTARIO',
'L6R0G4',
'2020/07/11',
'02:34:24',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44023.60722320';
}
else {$sql="update tb_Prospect set
col_LastName='A MISTRY',
col_FirstName='DIXITKUMAR'
where col_ID ='44023.60722320'";
$SQLMessage = '44023.60722320';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='dixitkumarmistry@gmail.com',
col_PhoneRes='4164172991',
col_PhoneBus='6477023157',
col_Cell1='',
col_Address='4 PAPE DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6R0G4'
where col_ID ='44023.60722320' and col_address= '' or col_Address is null";
$SQLMessage = 'dixitkumarmistry@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.69433636'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.69433636;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.69433636', 'SINGH SEKHON',
'REETGAGAN',
'reetgagan.sekhon@gmail.com',
'6474094232',
'6479996753',
'',
'35 ABBOTSBURY DR',
'',
'BRAMPTON',
'ONTARIO',
'L6X 0S4',
'2020/07/11',
'04:39:51',
'Mount',
'Mount Pleasant (T)',
'P',
'',
'')";
$SQLMessage = '44023.69433636';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH SEKHON',
col_FirstName='REETGAGAN'
where col_ID ='44023.69433636'";
$SQLMessage = '44023.69433636';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='reetgagan.sekhon@gmail.com',
col_PhoneRes='6474094232',
col_PhoneBus='6479996753',
col_Cell1='',
col_Address='35 ABBOTSBURY DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6X 0S4'
where col_ID ='44023.69433636' and col_address= '' or col_Address is null";
$SQLMessage = 'reetgagan.sekhon@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.69433636'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.69433636;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.69433636', 'SINGH SEKHON',
'REETGAGAN',
'reetgagan.sekhon@gmail.com',
'6474094232',
'6479996753',
'',
'35 ABBOTSBURY DR',
'',
'BRAMPTON',
'ONTARIO',
'L6X 0S4',
'2020/07/11',
'04:39:51',
'Mount',
'Mount Pleasant (T)',
'P',
'',
'')";
$SQLMessage = '44023.69433636';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH SEKHON',
col_FirstName='REETGAGAN'
where col_ID ='44023.69433636'";
$SQLMessage = '44023.69433636';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='reetgagan.sekhon@gmail.com',
col_PhoneRes='6474094232',
col_PhoneBus='6479996753',
col_Cell1='',
col_Address='35 ABBOTSBURY DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6X 0S4'
where col_ID ='44023.69433636' and col_address= '' or col_Address is null";
$SQLMessage = 'reetgagan.sekhon@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.69433636'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.69433636;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.69433636', 'SINGH SEKHON',
'REETGAGAN',
'reetgagan.sekhon@gmail.com',
'6474094232',
'6479996753',
'',
'35 ABBOTSBURY DR',
'',
'BRAMPTON',
'ONTARIO',
'L6X 0S4',
'2020/07/11',
'04:39:51',
'Mount',
'Mount Pleasant (T)',
'P',
'',
'')";
$SQLMessage = '44023.69433636';
}
else {$sql="update tb_Prospect set
col_LastName='SINGH SEKHON',
col_FirstName='REETGAGAN'
where col_ID ='44023.69433636'";
$SQLMessage = '44023.69433636';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='reetgagan.sekhon@gmail.com',
col_PhoneRes='6474094232',
col_PhoneBus='6479996753',
col_Cell1='',
col_Address='35 ABBOTSBURY DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6X 0S4'
where col_ID ='44023.69433636' and col_address= '' or col_Address is null";
$SQLMessage = 'reetgagan.sekhon@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44024.72556436'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44024.72556436;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44024.72556436', 'DHAWAN',
'ROHIT',
'rohitdhawan84@hotmail.com',
'4379964741',
'',
'',
'9 DUFAY RD ',
'',
'BRAMPTON',
'ONTARIO',
'L7A4A1',
'2020/07/12',
'05:24:49',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44024.72556436';
}
else {$sql="update tb_Prospect set
col_LastName='DHAWAN',
col_FirstName='ROHIT'
where col_ID ='44024.72556436'";
$SQLMessage = '44024.72556436';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='rohitdhawan84@hotmail.com',
col_PhoneRes='4379964741',
col_PhoneBus='',
col_Cell1='',
col_Address='9 DUFAY RD ',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A4A1'
where col_ID ='44024.72556436' and col_address= '' or col_Address is null";
$SQLMessage = 'rohitdhawan84@hotmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.72361368'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.72361368;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.72361368', 'DHAWAN',
'ROHIT',
'arkhan85@gmail.com',
'4166168199',
'',
'',
'204 SKY HARBOUR DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y 2Z7',
'2020/07/11',
'05:22:00',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44023.72361368';
}
else {$sql="update tb_Prospect set
col_LastName='DHAWAN',
col_FirstName='ROHIT'
where col_ID ='44023.72361368'";
$SQLMessage = '44023.72361368';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='arkhan85@gmail.com',
col_PhoneRes='4166168199',
col_PhoneBus='',
col_Cell1='',
col_Address='204 SKY HARBOUR DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y 2Z7'
where col_ID ='44023.72361368' and col_address= '' or col_Address is null";
$SQLMessage = 'arkhan85@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.72361368'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.72361368;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.72361368', 'DHAWAN',
'ROHIT',
'arkhan85@gmail.com',
'4166168199',
'',
'',
'204 SKY HARBOUR DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y 2Z7',
'2020/07/11',
'05:22:00',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44023.72361368';
}
else {$sql="update tb_Prospect set
col_LastName='DHAWAN',
col_FirstName='ROHIT'
where col_ID ='44023.72361368'";
$SQLMessage = '44023.72361368';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='arkhan85@gmail.com',
col_PhoneRes='4166168199',
col_PhoneBus='',
col_Cell1='',
col_Address='204 SKY HARBOUR DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y 2Z7'
where col_ID ='44023.72361368' and col_address= '' or col_Address is null";
$SQLMessage = 'arkhan85@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44023.72361368'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44023.72361368;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44023.72361368', 'DHAWAN',
'ROHIT',
'arkhan85@gmail.com',
'4166168199',
'',
'',
'204 SKY HARBOUR DR',
'',
'BRAMPTON',
'ONTARIO',
'L6Y 2Z7',
'2020/07/11',
'05:22:00',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44023.72361368';
}
else {$sql="update tb_Prospect set
col_LastName='DHAWAN',
col_FirstName='ROHIT'
where col_ID ='44023.72361368'";
$SQLMessage = '44023.72361368';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='arkhan85@gmail.com',
col_PhoneRes='4166168199',
col_PhoneBus='',
col_Cell1='',
col_Address='204 SKY HARBOUR DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6Y 2Z7'
where col_ID ='44023.72361368' and col_address= '' or col_Address is null";
$SQLMessage = 'arkhan85@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44027.68376657'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44027.68376657;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44027.68376657', 'KAUR BAL',
'HARJEET',
'harjeetbal73@gmail.com',
'4167297956',
'',
'',
'381 QUEEN MARY DRIVE',
'',
'BRAMPTON',
'ONTARIO',
'L7A3T1',
'2020/07/15',
'04:24:37',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44027.68376657';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR BAL',
col_FirstName='HARJEET'
where col_ID ='44027.68376657'";
$SQLMessage = '44027.68376657';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harjeetbal73@gmail.com',
col_PhoneRes='4167297956',
col_PhoneBus='',
col_Cell1='',
col_Address='381 QUEEN MARY DRIVE',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A3T1'
where col_ID ='44027.68376657' and col_address= '' or col_Address is null";
$SQLMessage = 'harjeetbal73@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44027.68376657'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44027.68376657;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44027.68376657', 'KAUR BAL',
'HARJEET',
'harjeetbal73@gmail.com',
'4167297956',
'',
'',
'381 QUEEN MARY DRIVE',
'',
'BRAMPTON',
'ONTARIO',
'L7A3T1',
'2020/07/15',
'04:24:37',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44027.68376657';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR BAL',
col_FirstName='HARJEET'
where col_ID ='44027.68376657'";
$SQLMessage = '44027.68376657';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harjeetbal73@gmail.com',
col_PhoneRes='4167297956',
col_PhoneBus='',
col_Cell1='',
col_Address='381 QUEEN MARY DRIVE',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A3T1'
where col_ID ='44027.68376657' and col_address= '' or col_Address is null";
$SQLMessage = 'harjeetbal73@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44027.68376657'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44027.68376657;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44027.68376657', 'KAUR BAL',
'HARJEET',
'harjeetbal73@gmail.com',
'4167297956',
'',
'',
'381 QUEEN MARY DRIVE',
'',
'BRAMPTON',
'ONTARIO',
'L7A3T1',
'2020/07/15',
'04:24:37',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44027.68376657';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR BAL',
col_FirstName='HARJEET'
where col_ID ='44027.68376657'";
$SQLMessage = '44027.68376657';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='harjeetbal73@gmail.com',
col_PhoneRes='4167297956',
col_PhoneBus='',
col_Cell1='',
col_Address='381 QUEEN MARY DRIVE',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L7A3T1'
where col_ID ='44027.68376657' and col_address= '' or col_Address is null";
$SQLMessage = 'harjeetbal73@gmail.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44027.71878780'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44027.71878780;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44027.71878780', 'KAUR HUNDEL',
'NARINDER',
'narinderhundel@yahoo.ca',
'4164178722',
'4163569766',
'',
'21 OSHAWA DR',
'',
'BRAMPTON',
'ONTARIO',
'L6P3W2',
'2020/07/15',
'05:15:03',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44027.71878780';
}
else {$sql="update tb_Prospect set
col_LastName='KAUR HUNDEL',
col_FirstName='NARINDER'
where col_ID ='44027.71878780'";
$SQLMessage = '44027.71878780';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='narinderhundel@yahoo.ca',
col_PhoneRes='4164178722',
col_PhoneBus='4163569766',
col_Cell1='',
col_Address='21 OSHAWA DR',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6P3W2'
where col_ID ='44027.71878780' and col_address= '' or col_Address is null";
$SQLMessage = 'narinderhundel@yahoo.ca';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
$sql= "select col_ID from tb_Prospect where
col_ID = '44027.76645085'";
$result = mysqli_query($dblink, $sql);
$AnyReturned =mysqli_num_rows($result);
$SQLMessage = "";
echo "$AnyReturned
";
if ($AnyReturned <1)
{
echo 44027.76645085;
$sql="insert into tb_Prospect (col_ID,col_LastName,col_FirstName,col_Email, col_PhoneRes,
col_PhoneBus,col_Cell1, col_Address,col_Apartment,col_City,col_Province,col_PostalCode,
col_StatusDate,col_StatusTime,col_Salesperson,col_Centre,col_StatusType,
col_ExtBus,col_Salutation) values
( '44027.76645085', 'PAULLYKNIG AGBUGBA',
'CHIMA',
'paulrenzon@yahoo.com',
'6475698735',
'9054532800',
'',
'1105-64 BRAMALEA ROAD',
'',
'BRAMPTON',
'ONTARIO',
'L6T2W8',
'2020/07/15',
'06:23:41',
'Mount',
'Mount Pleasant (T)',
'C',
'',
'')";
$SQLMessage = '44027.76645085';
}
else {$sql="update tb_Prospect set
col_LastName='PAULLYKNIG AGBUGBA',
col_FirstName='CHIMA'
where col_ID ='44027.76645085'";
$SQLMessage = '44027.76645085';
}
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Deal $SQLMessage.
";
}
$sql="update tb_Prospect set
col_Email='paulrenzon@yahoo.com',
col_PhoneRes='6475698735',
col_PhoneBus='9054532800',
col_Cell1='',
col_Address='1105-64 BRAMALEA ROAD',
col_Apartment='',
col_City='BRAMPTON',
col_Province='ONTARIO',
col_PostalCode='L6T2W8'
where col_ID ='44027.76645085' and col_address= '' or col_Address is null";
$SQLMessage = 'paulrenzon@yahoo.com';
$result = mysqli_query($dblink, $sql);
if (mysqli_error($dblink) <> "")
{
$VarError = mysqli_sqlstate($dblink);
echo "Error of $sql was $VarError.
";
$VarEveryThingIsOkay = 'False';
}
else
{
echo "Email Added $SQLMessage.
";
}
if ($VarEveryThingIsOkay == "False")
{
$VarFrom = "TOWNWOOD60301.PHP";
$VarTo = "../../../_webreporterrors/TOWNWOOD60301.PHP";
$copy = copy($VarFrom,$VarTo);
if ($copy)
{
echo "Copy Succeded";
}
Else
{
echo "Copy Failed";
}
}
?>
Warning: include(../CMSheaderPointer.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 4094
Warning: include(../CMSheaderPointer.inc) [function.include]: failed to open stream: No such file or directory in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 4094
Warning: include() [function.include]: Failed opening '../CMSheaderPointer.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 4094
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/bstapps/public_html/_webreporterrors/TOWNWOOD60301.PHP on line 4102