Thread

Why would this SQL query not work, when run in the Query Module tags:

{exp:query sql="SELECT SUM(prices.field_id_45) AS total FROM exp_weblog_data AS prices INNER JOIN exp_weblog_titles AS titles ON titles.entry_id = prices.entry_id AND titles.status = "open";"}
{total}
{/exp:query}

You say it doesn’t work but what exactly does that mean? Does it do anything at all?

You may just need to change your quotes on the status though :

{exp:query sql="

SELECT
        SUM(prices.field_id_45) AS total
FROM
        exp_weblog_data
AS
        prices
INNER JOIN
        exp_weblog_titles
        AS titles
ON
        titles.entry_id = prices.entry_id
AND
        titles.status = 'open'
"}

{total}

{/exp:query}

Also you don’t need the semi-colon in there when dealing with the query module.

Hope that helps a bit.

Best wishes,

Mark

Yeah it just wasn’t outputting anything. It should output a number. The query worked when I ran it in phpmyadmin just not in query module. I’ll give this a go though 😊 thanks for your help.

…The query worked when I ran it in phpmyadmin just not in query module…

Yep probably the quotes I reckon. Let me know how it goes.

Best wishes,

Mark

Thanks Mark, let us know if that works for you MAYO