The sql_count() function returns the number of rows for a selection resource opened with sql_select().
It accepts 3 parameters:
$res is the resource identifier for a selection,$serveur,$option.It is used as shown below:
$res = sql_select('column', 'table');
if ($res and sql_count($res)>2) {
// checks to see if there are at least 3 rows in the results!
}
Possible application: display a count of the total number of elements.
if ($res = sql_select('titre', 'spip_rubriques', 'id_parent=0')) {
$n = sql_count($res);
$i = 0;
while ($r = sql_fetch($res)) {
echo "Section " . ++$i . " / $n : $r[titre]<br />";
// e.g. Section 3 / 12 : La fleur au vent
}
}
Author Published : 16/05/10 Updated : 12/03/23
Translations : English, français