I am building a quiz database and am keen to ensure that a person is never asked a question that they upload and also that they never get asked a question more than once. Below is some background information.
I have a table as follows:
questionID (autonumber PK)
memberID (number - unique to each member)
question (question to ask the individual e.g. What is my name?)
correctAnswer (answer to question e.g. Colin)
My first step is to obtain all the questions that have not been uploaded by the user which I find easy enough to do. I also have the following table:
memberAnswerID (autonumber pk)
memberID (the unique member number id FK)
questionID (the unique question id FK)
memberAnswer (memners answer e.g. Alan)
How can I create the query where I select ONE question randomly that was not uploaded by the person answering it and that they have not already answered before. I hope the question makes sense?
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption. Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…