$select = sql_get_select(array( 'r.titre AS t', 'r.id_rubrique AS id' ), array( 'spip_rubriques AS r' )); // create the view sql_create_view('spip_short_rub', $select); // use it: $titre = sql_getfetsel('t', 'spip_short_rub', 'id=8');