Notice: Undefined index: club_id in /home/jnorthey/public_html/sites/ on line 6

SELECT m.match_id, m.match_name, m.match_date, m.squadding_open, m.squadding_start, m.squadding_end, m.start_time, m.max_competitors, max_squads, c.club_name, c.club_email FROM match_details AS m JOIN club AS c ON c.club_id = m.club_id WHERE m.club_id = ORDER BY m.match_date DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.match_date DESC' at line 21