# How should i organize mysql db and tables in this case?

**URL:** https://forum.kirupa.com/t/how-should-i-organize-mysql-db-and-tables-in-this-case/122884
**Category:** Uncategorized
**Created:** [September 17, 2004, 11:13pm UTC](https://forum.kirupa.com/t/how-should-i-organize-mysql-db-and-tables-in-this-case/122884 "2004-09-17T23:13:57Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![alapimba](https://avatars.discourse-cdn.com/v4/letter/a/ea666f/32.png) [@alapimba](https://forum.kirupa.com/u/alapimba)
#### Post date: [September 17, 2004, 11:13pm UTC](https://forum.kirupa.com/t/how-should-i-organize-mysql-db-and-tables-in-this-case/122884/1 "2004-09-17T23:13:57Z")

</div>

hello,  
i’m making a site like this: [www.iusedtobelieve.com](http://www.iusedtobelieve.com/) but i’m not sure how to make my database.

i was thinking in make a table with “id” “title” “text” “author” and “visible”(to change between visible or temporary hide, while i don’t accept the submission)  
but i guess this will give me many problems to put all titles together in the same table when i have many entrys.  
so i thought i should make a table for each title… but then i don’t know how to query the db for the latest 10 entrys don’t matter which title it was.  
maybe i should not organize my tables this way… this was how i imagine it.  
can someone help me a bit with this?  
if were you how you would make a site where the structure will be the same that the one i mentioned before but with a different subject.

Thanks in advance for any advices and help.