1
vote
1answer
63 views

How to store option key names

I have to store some properties in a database properties table which looks like this: CREATE TABLE `property` ( `id` int(11) NOT NULL AUTO_INCREMENT, `computer_name` varchar(64) NOT NULL, ...
0
votes
1answer
236 views

displaying data from from many-to-many table

ok, I'm new with MySQL, and this is a simple exercise for practice, so please bare with me. My goal is to display all posts with their categories underneath them. The code below accomplishes this, ...
2
votes
2answers
741 views

Need advice for my simple shopping cart's database structure

I’m trying to make a simple shopping cart application in PHP and am unsure of how to structure the database. I believe there are three tables that I need (but I could be wrong!): 1. products table ...
4
votes
1answer
207 views

PHP data structure review and critique

I have been working lately on an educational framework project to learn more about web development and problems that arise in more complex applications. Part of the framework's principles is to be as ...