Encerrado

Mysql Query Needed

Superesponder Email System

What I am trying to do is make a query that would tell the user how many emails the system sent today, in the past week, month to date and total emails sent. I am attaching 2 excel files from the tables and 2 scrips [url removed, login to view] and [url removed, login to view] script

Table: aptiresrecipients

owner = User account name

nexttime = time the next email should go out

nextmail = number of days from the first email that this email goes out (first email is an autoresponder goes out ASAP)

realname = Name given by client

urlfrom = If our form is used the url form the form submit

httpfrom = IP address of lead from form submit

reference = custom imputs from form submit

timesubscribed = time when the lead first hit the database

email = email address of the lead

bounces = number of times the email has bounced when trying to send

Table: aptiresresponses

owner = User account name

days = number of days from the first message

messageloc = username + the number of days from the first message

subject subject of the email

messagetype = code to know how to send (text, html or both)

textmessage = message body put into text field

htmlmessage = html code put into html field

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Linux Perl and Mysql

Habilidades: Engenharia, MySQL, Perl, PHP, Arquitetura de software, Teste de Software

Ver mais: php scrips, n query, send query, query table, mysql query, excel work request tracker, excel client tracker, html email mysql, mysql tracker, php mysql lead distribution system, mysql excel query, mysql source excel, mysql lead, excel query mysql, autoresponder lead, perl email subject, excel custom number, tracker database, install mysql url, package tracker, query email, mysql php tracker, mysql date field, bounces, excel number custom

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #2962739

6 freelancers estão ofertando em média $40 para este trabalho

mihaiscortaru

See private message.

$50 USD in 10 dias
(159 Comentários)
6.0
ekam

See private message.

$21.25 USD in 10 dias
(110 Comentários)
5.7
tucowsvw

See private message.

$21.25 USD in 10 dias
(11 Comentários)
2.6
vlad2005dev

See private message.

$85 USD in 10 dias
(3 Comentários)
1.3
jdehaerne

See private message.

$42.5 USD in 10 dias
(1 Comentário)
0.3
kwesistewart

See private message.

$21.25 USD in 10 dias
(0 Comentários)
0.0