MySQL-Client-Version: 5.0.27
Hi Koelle, your Plugin works perfectly fine with me. The only problem I have is, when inserting the standings as a widget it shows the following text before displaying the table as it should be. What can I do to get rid of it
WordPress database error: [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 ‘(NOW(), date) < 0 AND (home_team = 1 OR away_team = 1) OR]
SELECT home_team, away_team, DATE_FORMAT(date, ‘%Y-%m-%d %H:%i’) AS date, DATE_FORMAT(date, ‘%e’) AS day, DATE_FORMAT(date, ‘%c’) AS month, DATE_FORMAT(date, ‘%Y’) AS year, DATE_FORMAT(date, ‘%H’) AS hour, DATE_FORMAT(date, ‘%i’) AS minutes, match_day, location, league_id, home_points, away_points, overtime, penalty, winner_id, post_id, points2, id FROM wp_leaguemanager_matches WHERE league_id = ‘1’ AND DATEDIFF(NOW(), date) < 0 AND (home_team = 1 OR away_team = 1) ORDER BY date ASC</ blockquote>