[SOLVED] Limiting mulitple database entries to one
Posted: Thu Jan 13, 2005 12:50 pm
This is my question,
I'm designing a database system that enables you to select your specific car. First you pick the model, then the year, then the engine type. What I want the user to be able to do is select the model and then it comes up with a list of years available. The way the database is set up is that there is the model and year are used multiple times in different rows. When the mysql is called for a specific year, I want it to be able to put that year once even though it is in the database multiple times. For example, if the user selects the model "A4" and there is 4 entries in the database for a 1999 A4. The next page will show all the years that the A4 is avaliable. I want it to just echo one year that the car is avaliable even if there is multiple entries of that year. Is this possible? If you need more explination please reply and I'll explain in more detail. Thanks.
I'm designing a database system that enables you to select your specific car. First you pick the model, then the year, then the engine type. What I want the user to be able to do is select the model and then it comes up with a list of years available. The way the database is set up is that there is the model and year are used multiple times in different rows. When the mysql is called for a specific year, I want it to be able to put that year once even though it is in the database multiple times. For example, if the user selects the model "A4" and there is 4 entries in the database for a 1999 A4. The next page will show all the years that the A4 is avaliable. I want it to just echo one year that the car is avaliable even if there is multiple entries of that year. Is this possible? If you need more explination please reply and I'll explain in more detail. Thanks.