Thread

Moderator’s note: Moved to Howto.

Hi,

I was wondering if it is possible to display an email address for each comment displayed under an weblog post.

I run weekly giveaways and it is quite annoying having to find emails by SQL queries in the admin section of the control panel. Last time I checked the documentation there was no option to display the email address.

cheers,
Peter

url or email is about the best you can do.

I was afraid that was going to be the answer. Thanks Sean.

You might be able to do it using the query module, but I wouldn’t know where to start.

It looks to me as though the e-mail and also the URL of the poster gets saved to the same exp_comments table so you should be able to make a fairly simple SQL query something like this :

{exp:query sql="
SELECT email, url FROM exp_comments WHERE comment_id = '{comment_id}'
"}
{if email != ""}
{email}
{if:elseif url !=""}
{url}
{/if}
{/exp:query}

That would get placed inside your {exp:comment:entries} tag. This should bring back the e-mail (if one was supplied) and if not it would bring back the url instead. Obviously you would need to place the html code around those variables to make them into valid e-mail or URL links but that should hopefully get you what you are looking for.

Best wishes,

Mark

Oh wow! Thanks Mark. I will try that later tonight!

Oh wow! Thanks Mark. I will try that later tonight!

No problem at all. I didn’t actually test it out yet but I’m pretty sure it will work as it is a nice simple query and I can see from looking at a site I have with comments on that they get stored to that table so should all work as advertised hopefully.

Anyway let me know how it goes.

Best wishes,

Mark

Hi Mark,

Sorry for the late reply. Works like a charm! prob solved.

Hi Mark,

Sorry for the late reply. Works like a charm! prob solved.

Excellent news! 😊

Glad it worked out for you.

Best wishes,

Mark