https://www.webmaster-forums.net/crss/node/1024861 en https://www.webmaster-forums.net/web-database-development/building-queue-dvds#comment-1151958 <p>You should have three tables (at least).</p> <p>1. Users<br /> 2. DVDs<br /> 3. Queue (lookup table of users/dvds)</p> <p>Ideally you wouldn't use the person's name, nor the name of the DVD, but rather their unique id number.</p> Sat, 22 May 2004 19:41:42 +0000 Suzanne comment 1151958 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/building-queue-dvds#comment-1151944 <p>So I would build a table in my database and populate it with the names of the people I know are borrowing DVDs from me. I have built in the ability for the check out page to send to the database the name of the person requesting to borrow a movie. Would I just add to that code for the queue table or do I need to build another cfm page for that to work?</p> Sat, 22 May 2004 17:15:56 +0000 cgacfox comment 1151944 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/building-queue-dvds#comment-1151803 <p>Similar to what's checked out, you would have a lookup table of user+dvd and they can add or delete from that table when they add/delete from their list or queue.</p> <p>So:</p> <p><div class="codeblock"><code>user&nbsp; |&nbsp; dvd_id<br />---------------<br />1&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1<br />2&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 2<br />2&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 4<br />2&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 12<br />1&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 3<br />1&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 4</code></div>'</p> Thu, 20 May 2004 19:27:07 +0000 Suzanne comment 1151803 at https://www.webmaster-forums.net