Thread

Is this a bug? or did I do something wrong here?

{exp:query limit="5" paginate="bottom" sql="SELECT em.member_id, emd.member_id AS m_id, emd.m_field_id_1 AS first_name, emd.m_field_id_2 AS last_name, em.email AS email FROM exp_member_data AS emd JOIN exp_members AS em WHERE emd.m_field_id_27= '{embed:mem_id}’ AND em.member_id = emd.member_id “}
             
               
{paginate}
  Page {current_page} of {total_pages}
  {pagination_links}
{/paginate}
             
{/exp:query}

Query is correct when tested on phpMyAdmin..

Paginaton won’t seem to work? I keep on clicking 2 (for page 2) but still it won’t proceed to the next 5 entries?

Any help? Thanks! 😊

any help please?

Thanks!