Re: Perl & MySQl query syntax

2002-09-23 Thread Felix Geerinckx
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:

Re: Perl & MySQl query syntax

2002-09-22 Thread Wiggins d'Anconia
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