Database Storage and Relationship

Heya,

I’m after to find out how the images are stored in the database and then the relationship that relates them to the correct taxonomy.

I’ve been able to find the image in both the posts and postmeta tables, and then I can find taxonomy in the terms table – but cannot see how the two link as there is no reference to either in the term relationships table.

The reason why I want to know is that we have created a new database table which holds the term id, and other information, and when I query this table I want to get the term details but also get the taxonomy image which has been saved against it. This is so that it can be displayed on a page, but we are using plain old SQL to retrieve the term information from our table – so cannot use the standard functions.

Thanks,

Bev

http://ww.wp.xz.cn/extend/plugins/taxonomy-images/