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 '' at line 1
SELECT ID,Name FROM Sports_Centres sc WHERE sc.ID=
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 a.Name' at line 5
SELECT DISTINCT(a.Name) as Activity, a.ID as Activity_ID
FROM Activities_Day_Time adt
JOIN Sports_Centres_Rooms scr ON scr.ID = adt.Sports_Centres_RoomsID
JOIN Sports_Centres sc ON scr.Sports_CentresID=sc.ID
JOIN Activities a ON a.ID=adt.ActivityID WHERE sc.ID= ORDER BY a.Name
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 R.Name' at line 1
SELECT R.Name as Name, R.ID as ID FROM Rooms R JOIN Sports_Centres_Rooms SCR ON R.ID=SCR.RoomsID WHERE SCR.Sports_CentresID= ORDER BY R.Name