Perl & MySQl query syntax

2002-09-22 Thread larry lefthook
Hi! What's the right syntax using a variable with Perl & MySQL query? I got an example for PHP: #$exp_time = time()-86400; #$query = "DELETE FROM cl_temp_users WHERE sign_up_date < $exp_time;" ; But with Perl it does not work, like I have tried below. How to put my $sth line with prepare right so

perl script not run by cron

2002-09-17 Thread larry lefthook
Hi! I have modified gsmcontrol.pl (yty.net) as contrologo.pl. & I wonder why my script is not run by crontab when it works when I run it by hand. I have a file for the script in /var/gsm/in and when I run contrologo.pl from commandline it sends sms message (logo) using external program (gnokii)