Hall of Fame

1. angelIII116,364
2. theGhost...102,090
3. Ray_Pas...87,646
4. nemws177,236
5. leakim97162,288
6. Sharath_...51,725
7. HainKurt45,200
8. arnold41,480
9. reza_rad40,766
10. mwvisa131,582
11. kalmax26,490
12. john-for...24,368
13. tigin4423,904
14. ralmada21,900
15. ushastry21,518
16. ViaTom20,768
17. hielo19,875
18. DrDamnit19,800
19. profya19,603
20. Kdo18,800
20. _agx_18,800
22. jet-black18,475
23. yodercm18,244
24. matthews...17,375
25. rrjegan1716,668

1. angelIII2,921,133
2. todd_far...1,724,617
3. ushastry1,285,027
4. snoyes_jw956,407
5. cxr732,381
6. Raynard7704,144
7. Ray_Pas...650,719
8. hernst42627,649
9. hielo575,265
10. Squeebee555,077
11. leannonn543,335
12. routinet519,629
13. yodercm413,319
14. theGhost...412,073
15. NovaDeni...391,149
16. racek387,674
17. virmaior371,637
18. fibo358,971
19. psadac355,445
20. nemws1352,932
21. mankowitz343,436
22. akshah123330,218
23. AdrianSRU321,878
24. mwvisa1310,016
25. gamebits267,671

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

Need some query help, having multiple outputs when I only need 1

Asked by jag5311 in MySQL Server

Let me see if I can straighten out that subject.

Here is my query so far

<cfquery name="games" datasource="#dsn#">
SELECT games.gamename, articles.gameID
FROM games INNER JOIN articles ON games.gameID=articles.gameID
WHERE articles.gameID>0 AND articles.typeID=1
</cfquery>

what that is saying is I want the gamename and gameID where the gameID's from two tables match. I also want what is outputted to make sure the gameID is greater then 0 and the articles typeID equals 1 (which is a cheat).

WHat is happening though, is that a game may very well have more then 1 cheat, so if gameID of 5 has multiple typeID=1, like this

gameID -------------typeID

5 ----------------1
5 -----------------1

etc..,

for an example, visit this link, http://www.gamecubecheats.info/gamecube-cheats.cfm

Notice the two NBA LIve 2003's. Currently in my database, there are two cheat articles associated with that game, so my query is currently working, its just that I only want the game to be shown once even if there are multiple cheats.

Make sense?

Thanks
Bryan

View the Solution FREE for 30 Days

[+][-]12/21/03 10:21 AM, ID: 9981729Accepted Solution

Your question has an Asker Certified™ answer! jag5311 verified that this solution worked for them--which means it will likely work for you, too. Click to view the solution free for 30-days now.

About this solution

Zone: MySQL Server

Solution Provided By: JakobA

Participating Experts: 1

Solution Grade: A