fields for a table in database
-
i want to develop a fresher website. i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
-
i want to develop a fresher website. i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
This is not even a SQL question. It's a common sense question. Whatever you want to include, put in the table. We don't know your requirements, and if you don't you shouldn't be doing this task.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
-
i want to develop a fresher website. i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
sritha wrote:
i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
which kind of new do you want to show?
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
-
i want to develop a fresher website. i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
To make the news module customizable and expandable, you should think of putting in few tables instead of a single table. NewsCategoryMaster --------------------- NewsCategoryID (PK) NewsCategory NewsParentCategoryID (As Foreign key linking to the NewsCategoryID of the same table) NewsMasterTable ------------------- NewsID NewsCategoryID Title Author NewsDescription PublishDate IsActive IsDeleted
-
sritha wrote:
i need to post the news for students in home page itself. for that i need to create a table at the backend which is related to news. i included the fields like news id title category subcategory author....................... can you please guide me for some more fields required for news table
which kind of new do you want to show?
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
One without a body, apparently.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp