2 ORDER BY username ASC;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { $groups[$row['id']] = $row['username']; } $selected = 0; $options[] = l10n('select user'); $options['a'] = '----------------------'; foreach ($groups as $metalist => $metalist2) { $options[$metalist] = $metalist2; } $template->assign( 'gestionA', array( 'OPTIONS' => $options, 'SELECTED' => $selected )); if (isset($_POST['submitchoixauteur'])) { $forbidden = get_sql_condition_FandF( array( 'visible_images' => 'id' ), 'AND' ); $page['section'] = 'See_photos_by_author'; $query = ' SELECT DISTINCT(id) FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE added_by = \''.$_POST['metalist'].'\' '.$forbidden.' '.$conf['order_by'].' ;'; $page = array_merge( $page, array( 'title' => ''.l10n('See photos by author').'', 'items' => array_from_query($query, 'id'), ) ); //read auteur list $groups = array(); $query = ' select id,username FROM ' . USERS_TABLE . ' WHERE id<>2 ORDER BY username ASC;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { $groups[$row['id']] = $row['username']; } $selected = $_POST['metalist']; foreach ($groups as $metalist => $metalist2) { $options[$metalist] = $metalist2; } $template->assign( 'gestionA', array( 'OPTIONS' => $options, 'SELECTED' => $selected )); } $template->assign('SPBA2', 'toto'); $template->set_filename('SPBA', realpath(SPBA_PATH.'pagespba.tpl')); $template->assign_var_from_handle('CONTENT', 'SPBA'); ?>