Where is author ID stored?

Hey Andrew

The author ID is stored in the exp_channel_titles table under the column ‘author_id’.

I want to query the exp_channel_data table for entries created by a particular author (actually the currently logged in user).

Have you considered just using the exp:channel:entries tag pair with the author_id parameter in use? I don’t know if that’s exactly what you need but though I’d point you in that direction just in case.

http://ellislab.com/expressionengine/user-guide/modules/channel/parameters.html#par_author_id

exp_channel_titles and you can relate the tables through entry_id. Also, consider this.

Great thanks for the pointer to the correct table, and yes I would normally just use the exp:channel:entries tags, but in this case I’m writing a query joining custom tables, so it wouldn’t apply.

Thanks again

Andrew