Hi
You can follow the OS commerce table structure, if you understand well.
Otherwise
Follow below format
------------------------
Category
Sub category
News table
Category
Cat id
Cat name
More fields
Sub category
Sub cat id
Cat id
Sub cat name
More fields
News
News id
Cat id
Sub cat id
News title
More fields
Thanks & regards,
Muthukumar Selvarasu,
Project Manager (Web Development),
Webmasters Ltd.
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Tedit kap
Sent: Tuesday, April 22, 2008 3:28 PM
To: [email protected]
Subject: [php_mysql] Database vs table
Question: I am building a site that is mainly a news portal site about
several categories of a specific subject... There will be other elements too
but it will be mainly a news portal site. What makes more sense - to create
separate databases for each category and then build news and othertables
under each db, or can I just use one db and build many tables under it, news
tables for each category, and other tables for each category. In the long
run, what makes more sense? As far as backing up, updating data, add more
tables in time, other aspects i can not thinnk of...Any advice? This is the
first time I am creating dtabases so I am having hard time to see the long
term...I mean, medium size or big newsportal websites for example, how would
they do, with a lot of different databases and few tables under, or with few
databases with many tables under? Thanks
__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
