| | |
|---|
| | | $order_by_sql = "GROUP BY mailuser_id ".$order_by_sql; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | return 'SELECT '.$app->listform->listDef['table'].'.*'.$extselect.' FROM '.$app->listform->listDef['table']."$join WHERE $sql_where $order_by_sql $limit_sql"; |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | $limits = array('5'=>'5','15'=>'15','25'=>'25','50'=>'50','100'=>'100','999999999' => 'all'); |
|---|
| | | |
|---|
| | | //* create options and set selected, if default -> 15 is selected |
|---|
| | | |
|---|
| | | $options = ''; |
|---|
| | | foreach($limits as $key => $val){ |
|---|
| | | $options .= '<option value="'.$key.'" '.(isset($_SESSION['search']['limit']) && $_SESSION['search']['limit'] == $key ? 'selected="selected"':'' ).(!isset($_SESSION['search']['limit']) && $key == '15' ? 'selected="selected"':'').'>'.$val.'</option>'; |
|---|
| | | } |
|---|
