sql_getfetsel

The sql_getfetsel() function retrieves the single column requested from the first row of the selection. It accepts the same parameters as the sql_select() function and is a short-cut for the combination of calling sql_fetsel() and array_shift(). Its parameters are: -# $select nominating the desired column, -# $from, -# $where, -# $groupby, -# $orderby, -# $limit, -# $having, -# $serveur, -# $option. It is used as shown below:
$colonne = sql_getfetsel('colonne', 'table', 'id_table=' . intval($id_table));
Note that an alias can also be defined as shown here:
$alias = sql_getfetsel('colonne AS alias', 'table', 'id_table=' . intval($id_table));

Example

Find out the sector for a section (rubrique):
$id_secteur = sql_getfetsel("id_secteur", "spip_rubriques", "id_rubrique=" . intval($id_rubrique));
The "Job Queue" plugin manages a list of scheduled tasks, so we can find out the date of the next task to be performed with this code:
$date = sql_getfetsel('date', 'spip_jobs', '', '', 'date', '0,1');

Author Mark Baber Published : Updated : 17/05/10

Translations : English, français