if ($Choice eq 't_datein') { if ($Choice2 eq 't_datein') { $query .= " ORDER BY $Choice $SortOrder, t_timein $SortOrder, $Choice2, t_timein $SortOrder"; } else { $query .= " ORDER BY $Choice $SortOrder, t_timein $SortOrder, $Choice2"; } } else { $query .= " ORDER BY $Choice $SortOrder, $Choice2"; } if ($Top ne 'All') { $query .= " LIMIT $Top"; } $sth = $dbh->prepare($query); $sth->execute();