
In MySQL table i am adding the fields of name,photo,video,age,category.in the category i have some subjects.if one person login into my-site the he upload the one video under one subject.then i want the following thing i want to see the uploaded videos under the one category of same type(for ex maths) but here i am not creating the separate table for each table. tell me procedure is it necessary to create different tables for each category.and also if admin add the one more subject under the category field in the web site page then it automatically save into MySQL.but i am not create the table for that subject under the category.is it possible to do that