' ' are reserved for string literals in SQL, your above syntax is placing a string literal (PlayerName) where you should place a column.
Your query should be:
"SELECT * FROM bigcardtable WHERE Category='GameUsed' ORDER BY PlayerName ASC"
Now a couple of points to make.
I understand that you are a Novice in this arena, and that is ok we were all at that point one time in our careers BUT you should not spam a thread like u just did. Errors happen, logic doesn't work, hey I've been there but you should not come here and spam a thread everytime the exection of your page changes. Try and work through the problem, try different things, RESEARCH!, but dont immedately come to the forum and look for your answer.
Personally, I will not answer people who have obviously not done any research on their problem and just want a 'fix' unfortunately, noone learns anything when someone completes a task for them.
Regarding Dreamweaver. I would suggest using a text editor of some sort (Notepad++ or PSPad) to code your ASP and the reasons for this are 2 fold:
1. Editors make code ugly and hard to debug.
2. You will never learn anything using DW. By actually coding in a text editor you force your self to learn syntax, albeit it takes longer "coding by hand".
Anyway, ill get down off my soap box, glad everything is resolved! ^^
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
Read this if you want to know how to get a correct reply for your question:
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^