Linking to tables together?


#1

Hi there,

I’m working on a CMS that will replace my current Movable Type
installation. I’ve a little problem with the main screen. I don’t
know if it’s a database schema bad design or it’s coding problem.

I’ve got two tables. One for the “links” and one for the “posts”. In
the main screen of the blog I’d like to show the “links” and “posts”
by date. I mean that I should be able to show for example the last 4
posts introduced + 2 links + 1 post + 3 links.

The solution I think is to use only one table for posts and links but
I prefer to make a combination of the posts and links because maybe
one day I’d like to show also pictures, books …

Which is the best solution to this problem?

Thanks a lot,

Francesc