Help for this page

Select Code to Download


  1. or download this
    my $query = $dbh->prepare("SELECT idOutbound, type, DAY(dateDue) FROM 
    +LD_Outbound WHERE (dateDue >= ? AND dateDue < ? + INTERVAL 1 MONTH) O
    +R (defaultDate >= ? AND defaultDate < ? + INTERVAL 1 MONTH)");
    $query->execute("$last_y-$last_m-01", "$last_y-$last_m-01", "$last_y-$
    +last_m-01", "$last_y-$last_m-01");
    
  2. or download this
    my $query = $dbh->prepare("SELECT idOutbound, type, DAY(dateDue) FROM 
    +LD_Outbound WHERE (dateDue >= ?:NOW AND dateDue < ?:NOW + INTERVAL 1 
    +MONTH) OR (defaultDate >= ?:NOW AND defaultDate < ?:NOW + INTERVAL 1 
    +MONTH)");
    $query->bind_param(:NOW, "$last_y-$last_m-01");
    $query->execute();