Fermé

PERL: MySQL CURTIME query to send Email Alert of modified

omitting the first few lines that are just calling the DB, they are fine, the rest looks like:

# PERL DBI CONNECT

$connect = DBI->connect($dsn, $user, $pw);

# PREPARE THE QUERY

$query = "SELECT name,job_title FROM cases_perm_cases WHERE date_modified>DATE_SUB(CURTIME(), - 60)";

$query_handle = $connect->prepare($query);

# EXECUTE THE QUERY

$query_handle->execute();

# BIND TABLE COLUMNS TO VARIABLES

$query_handle->bind_columns(undef, \$name, \$job_title);

# LOOP THROUGH RESULTS

while($query_handle->fetch()) {

print "$name,$job_title \n\n";

Compétences : Linux, MySQL, Perl, Administration Système

Voir plus : perl curtime, n query, send query, query table, dsn, db query, bind, query loop, dsn email, admin prepare, perl rest, fetch mysql, mysql fetch, query email, table perl, perl table, loop table, system rest, fetch results, connect query mysql, loop columns table mysql, select name, loop send, print email, mysql rest

Concernant l'employeur :
( 8 commentaires ) Orange, Thailand

N° du projet : #1031577

8 freelance ont fait une offre moyenne de 48 $ pour ce travail

srinichal

I can deliver the same asap

30 $ USD en 1 jour
(48 Commentaires)
6.3
gangabass

I can do this job for you. See PM for details.

30 $ USD en 0 jours
(171 Commentaires)
6.0
faylandperl

Hi, check pmb, I'm a 6 years Perl programmer. Thanks

40 $ USD en 1 jour
(45 Commentaires)
5.5
valleysoftware

I do that. See PMB to understand better my 100% Project completion rate.

45 $ USD en 0 jours
(20 Commentaires)
4.8
amsak

Placing bid

30 $ USD en 7 jours
(7 Commentaires)
3.4
seadz

I can do this for you.

30 $ USD en 1 jour
(6 Commentaires)
3.0
gKaller

Hi, I have good experience in Mysql. I await your contact

150 $ USD en 2 jours
(0 Commentaires)
0.0
plutomaster

I have rich experience in data processing and sending out HTML/TEXT alert email w/ Perl, and will give you packaged libraries to do this kind of work.

30 $ USD en 0 jours
(0 Commentaires)
1.0