Jump to content


This topic is now archived and is closed to further replies.


quick mysql query

Recommended Posts

I\'m trying to write a simple database to keep track of DVDs, and am having a little trouble visualising the structure. I could do with a little push in the right direction from someone who knows what they\'re doing :)


The problem:


A group of us have joined an online dvd rental site. We each have x requests that are submitted to the site at various occasions. We need to keep track of who has requested what. We also lend DVDs to each other and need a way of keeping track of who\'s got which DVD, and possibly when it was lent.


So, it\'s sort of a dual purpose application. Keeping track of who\'s requested a DVD for rental, and who\'s borrowed one from a friend.


This is the first time I\'ve done this since uni (about 7 years ago!) and I\'m, well, rusty would be an understatement ;)

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.