Foreach

[Xtremer360]

I'm trying to figure out why its saying Warning: Invalid argument supplied for foreach() in /home/content/y/a/n/yankeefaninkc/html/defiant/efedmanager/forms/booking.php on line 17. I thought I did the foreach loop right so far.

 

$eventid = $_GET['id'];

$query = "SELECT 
CONCAT_WS(' ', eventnames.eventname, events.label) AS event, 
DATE_FORMAT(events.bookingdate, '%M %d, %Y') AS bookingdate,
    events.nummatches AS nummatches
FROM 
events, eventnames
WHERE  events.event_id = eventnames.id AND events.id = '" . $eventid . "'";
    $result = mysqli_query ( $dbc, $query ); // Run The Query

foreach ($nummatches as $matchnum) {
    echo "Match # $matchnum";
    echo "<select class=dropdown name=matchtype id=matchtype title=Match Type>";
    echo "<option value=0>- Select -</option>";
    $query = 'SELECT id, matchtypename FROM matchtypes';
    $result = mysqli_query ( $dbc, $query ); // Run The Query
    while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
        print "<option value=\"".$row['id']."\">".$row['matchtypename']."</option>\r";
    }
}

[BlueSkyIS]

what is $nummatches?

[Xtremer360]

I just thought of something that's wrong. Nummatches is just the number of matches for the event. Basically what I'm attempting to do is do some form stuff for as many matches for the event. So I need to have it separate out for each match.