Cancelado

eMail "Distinct" results of MySQL query

I need modifications/additions to the PHP code below that will accomplish two goals:

(1) eMail a list of all unique "TransferDate" values that are in records that will be deprecated when the "$deadify_stmt->execute()" is run.

(2) Although the DBRStatus value is being modified correctly as a result of this script, DBRDeadDate is not being set. I need the correction to my code to fix that.

======================================

Here are the relevant snips of my PHP code (it works other than setting the DBRDeadDate):

<?php

error_reporting(E_ALL);

ini_set('display_errors', 1);

include "[login to view URL]";

date_default_timezone_set('America/New_York');

/// Define comparison rules for determining which data lines need to be deprecated

$deadify = "UPDATE DBRData SET DBRStatus = 'Dead', DBRDeadDate=Now() WHERE ( ((ChargeID,FolioID,Rstatus,CheckIn,CheckOut,CustomerID,FirstName,LastName,Address,City,State,PostalCode,Phone,TransferType,TransferDate,Item,Description,Quantity,Rate,Price,Discount,Channel,RateType,ChannelNotes,UserNotes,CreateBy,CreateDate,ModifyBy,ModifyDate)

NOT IN (SELECT ChargeID,FolioID,Rstatus,CheckIn,CheckOut,CustomerID,FirstName,LastName,Address,City,State,PostalCode,Phone,TransferType,TransferDate,Item,Description,Quantity,Rate,Price,Discount,Channel,RateType,ChannelNotes,UserNotes,CreateBy,CreateDate,ModifyBy,ModifyDate FROM ImportCSV))

AND FolioID IN (SELECT DISTINCT FolioId FROM ImportCSV AS FolioID ORDER BY FolioID)

AND FolioID != 0

AND TransferDate > (SELECT min(TransferDate) FROM ImportCSV)

AND DBRStatus = 'Active'

)";

/// TODO: Add eMail scripting here

/// Run deadify/deprecation routine on records

$deadify_stmt = $pdo->prepare($deadify);

$deadify_stmt->execute() or die(print_r($insert->errorInfo(), true));

$deadify_count = $deadify_stmt->rowCount();

$fileName = "../../data/[login to view URL]";

$fileDate=date ("Y-m-d H:i:s.", filemtime($fileName));

$imported = "UPDATE Resync SET Deadified = $deadify_count WHERE Fdate = '$fileDate'";

$imported_stmt = $pdo->prepare($imported);

$imported_stmt->execute() or die(print_r($insert->errorInfo(), true));

Habilidades: HTML, MySQL, PHP

Veja mais: email csv file mysql query, drill results mysql query, display results mysql query, script mysql query csv file email, mysql query results date range php, mysql query display results csv file, perl mysql query results email, mysql query range results, displaying results mysql query, perl mysql query result email, perl crontab mysql query result email, perl reading mysql query results, mysql query send email, perl mysql query email, google map mysql query results

Acerca do Empregador:
( 28 comentários ) Ashland, United States

ID do Projeto: #16483737

19 freelancers estão ofertando em média $137 para esse trabalho

rinsadsl

Hi, I can fix this email related code and do the DBRDeadDate issue as well. Award with confidence, I can do a great job to you

$222 USD in 3 dias
(1058 Comentários)
8.8
$147 USD in 3 dias
(633 Comentários)
9.0
mahamadali

A proposal has not yet been provided

$83 USD em 1 dia
(282 Comentários)
7.0
Shopify

Hello, Dear client we have checked your project [ ] We can provide you an appealing, professional and RESPONSIVE website with functional tabs, attractive/revolution slider banners, modern layout and design of pages. Mais

$155 USD in 3 dias
(29 Comentários)
7.1
abstractsoftweb

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Mais

$155 USD in 3 dias
(118 Comentários)
7.2
bjrupani

Hello hiring member i am bhavika i can fix this i have good experience with php html,css,ajax,jquery ,javascript i have done this types of job in my past so you can trust in my skill so please give me chance to serve y Mais

$111 USD in 0 dias
(107 Comentários)
6.3
efforcoder

Hi, sir. Thanks for reviewing my proposal. I have seen your project very carefully. I am sure I can do your work asap. I have been developing web application for 5 years. PHP, MYSQL are my major skills. These are Mais

$155 USD in 3 dias
(47 Comentários)
5.8
$35 USD in 0 dias
(73 Comentários)
5.5
riteshjainindore

Dear revered, I hope you are doing good. I am a professional PHP developer with an experience of more than 5 years in creating and customizing PHP based websites, themes and plugins/modules. I am well equipped Mais

$155 USD in 3 dias
(10 Comentários)
5.5
$155 USD in 3 dias
(34 Comentários)
5.3
$100 USD em 1 dia
(93 Comentários)
5.4
saikatkundued

I read your proposal and understand your need sir.. I can do this project as I have already done this type of job..Want to work with you...

$100 USD in 3 dias
(15 Comentários)
5.0
fastwebsoft

hello sir, I have read your requirement carefully. I can do within few hour.. so I am perfect candidate for this job at lowest rate witth sure result. thanks

$35 USD em 1 dia
(20 Comentários)
5.0
deeptisangwar5

Hello, I have gone thoroughly your requirement and i understand the your requirement as you stated .I will work on your website from landing page to make complete website for your consideration. I will Create Eye-catc Mais

$155 USD in 3 dias
(3 Comentários)
3.6
ankitshow9

A proposal has not yet been provided

$88 USD in 3 dias
(2 Comentários)
3.3
fsdsolutions1

Hi I have reviewed your requirements for your preconceived project As all your requirements are crystal clear to me so i would like to discuss your project querries in more detail which would let me to quote y Mais

$155 USD in 3 dias
(1 Comentário)
3.3
$244 USD in 3 dias
(4 Comentários)
3.1
$155 USD in 3 dias
(2 Comentários)
0.0
$200 USD in 5 dias
(0 Comentários)
0.0