sql_fetsel

The sql_fetsel function returns the first row of results for a selection. It accepts the same parameters as the sql_select() function and is a short-cut for the combined call of sql_select() and sql_fetch(). Its parameters are: -# $select, -# $from, -# $where, -# $groupby, -# $orderby, -# $limit, -# $having, -# $serveur, -# $option. It is used as shown below:
$r = sql_fetsel('colonne', 'table');
// $r['colonne']

Example

Select the "id_trad" and "id_rubrique" columns of a given article:
$row = sql_fetsel("id_trad, id_rubrique", "spip_articles", "id_article=$id_article");
// $row['id_trad'] and $row['id_rubrique'] 
Select all the columns for a given news item:
$row = sql_fetsel("*", "spip_breves", "id_breve=$id_breve");

Author Mark Baber Published : Updated : 02/06/10

Translations : English, français