my $sort_by = ($sort eq 'date') ? 'date_of' : 'user_name'; my $stmt = 'SELECT * FROM time_sheet WHERE user_id = ? ORDER BY '.$sort_by; my $user_time = $dbh->selectall_arrayref($stmt, {Slice => {}}, $user_id);