Help writing an SQL Query to find the channel of an entry
Development and Programming
Hello there EE forum members,
SQL is a little over my head and I have conducted Google and EE forum searches, but I am unable to find a solution (SQL, addon, built in functionality, etc.). I am wanting to find the channel of a particular entry in my database. I would assume it would be something like this…
SELECT channel_name FROM `exp_channels` WHERE entry_id = 63;It is kind of a reverse approach. We have an entry ID being displayed on a template but only an excerpt is showing, so we want to have a read more link to the entire entry, which is why we want the channel of the particular post included in the EE anchor link.
Thanks!
Hello igrandfunk,
You can read the channel name with something like:
SELECT c.channel_name
FROM exp_channel_titles AS t
JOIN exp_channels AS c ON t.channel_id = c.channel_id
WHERE t.entry_id = 'my_id'where ‘my_id’ is your entry id number.
Jack,
Thank you very much. This solution worked for me and I was able to learn how you called in the channel name/ID by joining the tables. Thanks again!