Club sponsors:
|
Fixture card
Error in query: SELECT tblItems.intItemID,strHeadLine,tblItems.intTypeID,tblItems.intClubID,tblItems.intVenueID,datItem,strTime,datExpiry,strDescription,tblItems.intResultID,strResult,strClubName,strWebsite,strResultName,strVenueName,strMapLink,strNotes,strTypeName,DATE_FORMAT(datItem,'%a %d-%b-%Y') as ItemDate, DATE_FORMAT(datItem,'%Y%m%d') as ISODate, DATE_FORMAT(datItem,'%M') as ItemMonth, DATE_FORMAT(datItem,'%d') as DayOfMonth, DATE_FORMAT(datItem,'%W') as DayOfWeek FROM (((tblItems LEFT JOIN tblClubs ON tblItems.intClubID = tblClubs.intClubID) LEFT JOIN tblTypes ON tblItems.intTypeID = tblTypes.intTypeID) LEFT JOIN tblResults ON tblItems.intResultID = tblResults.intResultID) LEFT JOIN tblVenues ON tblItems.intVenueID = tblVenues.intVenueID WHERE tblItems.intTypeID < 100 AND YEAR(datItem) = ORDER BY datItem, strTime. 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 datItem, strTime' at line 1
| | |
