Do you have a question? Post it now! No Registration Necessary. Now with pictures!
November 24, 2005, 8:50 am
rate this thread
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,
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,
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!!
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum