All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Low Alphabet with SQL query?

stefbourdon 16 Nov 2012 17:11 question, complete

Hi,

could you give me an example on how to use Low Alphabet with an expressionengine SQL query? I think I understand how Low Alphabet works with channel entries, but a query is not clear to me (I am new at Low Alphabet) The query code is:


    {exp:low_replace find="L'|D'|'T|'A|'S" replace="L’|D’|’T|’A|’S" multiple="yes"}
    {exp:query sql="SELECT DISTINCT field_id_48 AS my_location FROM exp_channel_data ORDER BY field_id_48"}
  • {my_location}

    • {/exp:query}
    {/exp:low_replace}


The query generates a list of place names, and I want to group them together under A, B, C, ...

Thanks in advance,

stef

Replies

  1. Low 16 Nov 2012 18:06

    Hi Stef,

    Not sure what you're trying to accomplish with that query. Low Alphabet will group all entries under their own letter out of the box. No need for a custom query.

  2. stefbourdon 16 Nov 2012 19:05

    OK,

    Thanks for you reply, I must have missed something, bit of a rush job. I will let you know what it turns out to

    Thanks & have a nice weekend,

    stef