Help - Search - Members - Calendar
Full Version: field names for mt_blog
Movable Type Community Forum > Additional Resources > Tips and Tricks
spk921803
Hi,

I'm trying to pull some data from mt_blog using sql query.
What are the field names for categories and archieves?
I tried
CODE
SELECT blog_catetories FROM mt_blog WHERE (blog_id = 5)

, but did not work. blog_category didn't work either.
Where can I get the field names for mt_blog?

Thank you
kadyellebee
If you have access to PHPMyAdmin on your server account, browsing through the tables to see what goes where is kinda fun. smile.gif

mt_category lists the names of the categories, and mt_placement has the entry ids connected with the category ids.

Does that help? If not, can you tell us what you are trying to do, and maybe we can point you in the right direction. smile.gif

Kristine
spk921803
i'm using phpmyadmin now.
thank you! biggrin.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.