How to manage topic in a table have a lof of Object

hacku69

i have just designed a database such as:

have id,sid,eid,title,message,author,picture,comments

id ==>auto Increment
sid==> such as objects
eid==>is small of objects

i have try post some topic. In my admin page, it's so difficult manage all topic.

If sort by ID is very confusion from Objects. and If sort by SID, difficult to manage the news topic...Please, show me how to manager all topic in this database. !!

Thks and Regards MR

laserlight

What exactly are "such as objects" and "is small of objects"? Incidentally, have you read PHP Builder's article on Database Normalization and Design Techniques?

hacku69

mytable

id- sid - eid - title - message-picture-commenrs-author
1-Hotnews-0-........................................................
2-Home Football -Coca - ----------------------------
2-Home Football -Pepsi - ----------------------------

2-Home Football -Number 1- ----------------------------
3-International Footbal - Seria A- ----------------------------
3-International Footbal - Premier- ----------------------------
3-International Footbal - Portugal- ----------------------------
4-others-0- ----------------------------
5-Sport and Life-0- ----------------------------
..

I have just posted this structure. please show me how to manage it. !Thk Regards

laserlight

For starters, you need to choose a more descriptive table name than "mytable". It looks like you also need a table or two for categories, and perhaps another for comments and authors.