I am designing a blog site in php where users can add manually related posts to a post.
I thought to use an auto increment integer for all posts related.
This is the table:
-related ( it's 0 if there aren't related posts or it contain an auto incremet integer that it is the same for all posts related )
I prefer not to use a "related table" if possible to avoid complex queries.
So I need a way to get an auto increment integer in this case or you can suggest me other solutions :)