on Sun, 22 Sep 2002 17:53:29 GMT, Wiggins D'Anconia wrote:
> larry lefthook wrote:
>> my $sth = $dbh->prepare('delete from cl_items WHERE date_time <
>> $exp_time2 ');
>>
>
> You are single quoting your statement which means $exp_time2 is taken
> literally rather than interpolated should be:
larry lefthook wrote:
> 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 m
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