x
 
Create New Page
 View Previous Changes    ( Last updated by Lisa Wess )

Number Of Entries In Gallery

The below Queries will give you the number of entries in your EE Gallery.

Number of entries for all galleries:

{exp:query sql="SELECT count(entry_id) AS count FROM exp_gallery_entries"}
{count}
{
/exp:query}

Number of entries for one specific gallery (replace the 1 with the ID number of the gallery):

{exp:query sql="SELECT count(entry_id) AS count FROM exp_gallery_entries WHERE gallery_id=1"}
{count}
{
/exp:query}

Category:Queries Category:Image Gallery

Categories: