Msg#: 4482636 posted 5:09 pm on Aug 7, 2012 (gmt 0)
Wonder if anyone here can help please. I posted this query on another forum a few days ago, but haven't really got the answer to my problem.
I am a complete novice with PHP and require some assistance if possible please.
This URL pulls up a stats page for a local football club. There are several different match types, League, Cup etc. If you select the "All" option it gives all results including; Bounce Game, Friendly and Testimonial.
I would like to add another option in the Match Type drop-down list that will be called "All Competitive" and for this to include all match types apart from; Friendly, Bounce Game, Testimonial - MatchTypeID - 6, 8 and 9.
I understand that I think I need a statement along the lines of:
"WHERE MatchTypeId NOT IN (6,8,9)"
But I haven't got a clue how to structure this, or where to add it.
The block of script that currently makes the call is as follows: