Hi Everyone
I've had a database query page running on a site for a few months:
(http://www.learningdirectory.info/search.php) with no problems.
The search page contains the following query:
SELECT CourseID, tblCourseInfo.ProviderID, tblCourseInfo.OccupationID,
tblCourseInfo.AuthorityID, tblOccupations.Occupation,
tblOccupations.OccupationID, tblProviders.ProviderID,
tblProviders.ProvName, tblAuthorities.AuthorityID,
tblAuthorities.Authority
FROM tblCourseInfo, tblOccupations, tblProviders, tblAuthorities
WHERE tblCourseInfo.ProviderID LIKE 'varProvider'
AND tblCourseInfo.OccupationID LIKE 'varOccupation'
AND tblCourseInfo.AuthorityID LIKE 'varAuthority'
AND tblCourseInfo.OccupationID LIKE tblOccupations.OccupationID
AND tblCourseInfo.ProviderID LIKE tblProviders.ProviderID
AND tblCourseInfo.AuthorityID LIKE tblAuthorities.AuthorityID
ORDER BY tblOccupations.Occupation, tblProviders.ProvName,
tblAuthorities.Authority
But in the last few days a message has appeared:
'The SELECT would examine more rows than MAX_JOIN_SIZE. Check your
WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the
SELECT is ok'
I understand that I need to add ''SET SQL_BIG_SELECTS=1' but could
someone please tell me where or how I add it? I haven't got a clue!!
Many thanks
Suffrinmick