Is there any way i can make the ASP code search for 2 items in the database and only display them on the page? I.E: search for MemberLVL and WhatGame and display only the ones that have what i am looking for? The URL i am trying to make it work with is (http://rse1.game-host.org/memlist2.asp), i want the code to only display whats on the page but only if the game they play is 'Both' or 'ST-A1'. I hope some one can help me with my problem.
The SQL statement you'd need would go a little something like this:
SELECT FIELDS FROM TABLE WHERE MemberLVL=x AND (WhatGame='Both' OR WhatGame='ST-A1')
You'll need to change the items highlighted in green to suit your needs and I'm assuming above that the MemberLVL field is a numeric field. If it's not, you'll need to enclose the value you're checking for in single quotes (MemberLVL='String')
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
dang you beat be to posting. I have it all done now, I got it working but then my ORDER BY 'SQL statement' wasn't working so i had to combined them together to make them work sooo i have every thing i need done and working just right. If you would like to take a peek at it then go to (http://rse1.game-host.org/signup.asp) but please when your done looking around delete your membership by going to the 'Membership" part of the menu and then going to "Change Details" and click the botton that says "Delete Membership", Thank you for the help.
Topic Locked
Posted - 27 January 2005 : 21:43:07
