Query EE Database Manually
Development and Programming
I manually maintain a Calendar of Events list. The EE portion of my sites hasn’t launched yet, but I want to start adding events to a database now. The events are displayed on 9 different domain names, but all the domains have access to the main mySQL database.
The question is, can I manually grab weblog entries to use on my sites that haven’t been converted to EE yet?
Something like:
$result = mysql_query ("SELECT * FROM someEEdatabase WHERE whatever!=''EE 1.6.8
Yes, you can certainly use a standard PHP / MySQL query to display those entries.
I think this may be more trouble than it is really worth, but I am having a hard time finding where that data is actually stored. I would think it would be in one of the exp_weblog tables but it doesn’t seem to be there.
Yes. You’ll probably want exp_weblog_titles and exp_weblog_data for regular weblog entries.