Please could make a dropdown list dependent videotutorial. using foreign keys and innodb please please category subcategory products date with a mysql database.
friend if possible by category, sub-category, product and date of publication.
and if you have time on the date of publication may be the last day, the last 3 days, the last week.
