Help required in selecting Match ID

[JEB]

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.

 

http://briskham.co.uk/playerstats/index.php

 

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 have attached a copy of the PHP file, could someone manage to help me out with this one please?

 

Many thanks

18780_.php

[Barand]

For All Competitive you need a query "... WHERE MatchTypeId NOT IN (6,8,9)"

[JEB]

Thanks - Like I saw I know absolutely nothing about PHP. Where would I put the block of code, and what would it look like to have an option in the list that says "All Competitive Matches".

 

Any help would be appreciated.

[JEB]

Hi - I have been attempting to do this myself, but just can't figure out what code and where I need to add. If anyone could help it would be really appreciated.