Dibatalkan

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));

Kemahiran: HTML, MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 28 ulasan ) Ashland, United States

ID Projek: #16483737

20 pekerja bebas membida secara purata $138 untuk pekerjaan ini

$147 USD dalam 3 hari
(621 Ulasan)
9.0
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 dalam 3 hari
(1040 Ulasan)
8.8
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. Lagi

$155 USD dalam 3 hari
(29 Ulasan)
7.1
mahamadali

A proposal has not yet been provided

$83 USD dalam sehari
(213 Ulasan)
6.8
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] Lagi

$155 USD dalam 3 hari
(114 Ulasan)
7.1
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 Lagi

$155 USD dalam 3 hari
(35 Ulasan)
5.8
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 Lagi

$111 USD dalam 0 hari
(86 Ulasan)
6.0
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 Lagi

$155 USD dalam 3 hari
(10 Ulasan)
5.5
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 dalam 3 hari
(15 Ulasan)
5.0
$155 USD dalam 3 hari
(30 Ulasan)
5.0
$100 USD dalam sehari
(75 Ulasan)
5.3
$35 USD dalam 0 hari
(64 Ulasan)
5.2
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 dalam sehari
(13 Ulasan)
4.7
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 Lagi

$155 USD dalam 3 hari
(3 Ulasan)
3.6
ankitshow9

A proposal has not yet been provided

$88 USD dalam 3 hari
(2 Ulasan)
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 Lagi

$155 USD dalam 3 hari
(1 Ulasan)
3.3
$244 USD dalam 3 hari
(4 Ulasan)
3.1
DnyaneshwerK24

We can start immediately, Dear Hiring Manager, Hope you are doing well I have gone through your project description i can do that you mentioned in description We have huge experience of website design, mobile ap Lagi

$155 USD dalam 3 hari
(9 Ulasan)
2.5
$155 USD dalam 3 hari
(2 Ulasan)
0.0
$200 USD dalam 5 hari
(0 Ulasan)
0.0