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.
[
briskham.co.uk...]
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:
?>
</select>
<select name="matchtype">
<option value="0"><?= $txt_all ?></option>
<?php
while($data = mysql_fetch_array($get_types))
{
if($data['MatchTypeID'] == $defaultmatchtypeid)
echo "<option value=\"$data[MatchTypeID]\" SELECTED>$data[MatchTypeName]</option>\n";
else
echo "<option value=\"$data[MatchTypeID]\">$data[MatchTypeName]</option>\n";
}
mysql_free_result($get_types);
?>
Could someone help put together the code I need so that this will work please?
Many thanks
