Help for this page

Select Code to Download


  1. or download this
    my $quer = "SELECT checklist.id FROM group_management,User_group_manag
    +ement_mapping,profiles,checklist,checklist_group_mapping WHERE User_g
    +roup_management_mapping.userid = $usr and  profiles.userid = User_gro
    +up_management_mapping.userid and group_management.id =User_group_mana
    +gement_mapping.groupid and checklist_group_mapping.checklist_id = che
    +cklist.id and checklist_group_mapping.group_id = group_management.id"
    +;
    my $query = $dbh -> prepare($quer);
    $query-> execute();
    
  2. or download this
    my $SQLquery = "
        SELECT checklist.id 
    ...
    
    my $sth = $dbh->prepare( $SQLquery );
    $sth->execute( $usr );