How to search multiple fields?
Posted: Sun Jul 25, 2010 11:51 pm
I'm still new at this, but struggling on slowly. I have a table in my db that details the characters in my WoW guild (sad, I know). The table has the following columns:
ID - primary key, auto increment, etc, etc
char1 - the character name
rank - characters guild rank
class - their class
max_lvl - yes/no to if they are max level
spec1 - their primary spec
spec2 - their secondary spec
role1 - the role defined by spec1, like tank, healer, etc
r1eg - yes/no to is the role 1 gear end-game level
role2 - the role defined by spec2
r2eg - yes/no to is the role 2 gear end game level
What I want to be able to do is search for (for example) all characters that are max level, have a tank spec, and that spec is end game geared.
I can do the form to post to a script, but have no clue how to go about this sort of search query. Could anybody point me in the right direction please?
Regards,
Balveda
ID - primary key, auto increment, etc, etc
char1 - the character name
rank - characters guild rank
class - their class
max_lvl - yes/no to if they are max level
spec1 - their primary spec
spec2 - their secondary spec
role1 - the role defined by spec1, like tank, healer, etc
r1eg - yes/no to is the role 1 gear end-game level
role2 - the role defined by spec2
r2eg - yes/no to is the role 2 gear end game level
What I want to be able to do is search for (for example) all characters that are max level, have a tank spec, and that spec is end game geared.
I can do the form to post to a script, but have no clue how to go about this sort of search query. Could anybody point me in the right direction please?
Regards,
Balveda