I am stuck with a server which is using MySQL 3.23.58.
I have written some PHP/MySQL code which doesn't work on my web server, but works just fine on my local machine because my local machine has a later version of MySQL.
The SQL I need to revise is
Can anyone tell me how to best re-write this query so that it will work on the older MySQL server?
MrsBean
I have written some PHP/MySQL code which doesn't work on my web server, but works just fine on my local machine because my local machine has a later version of MySQL.
The SQL I need to revise is
Code:
SELECT tblmembership.*, areasofpractice.areas FROM areasofpractice INNER JOIN (memberap INNER JOIN tblmembership ON memberap.wsuaaID = tblmembership.wsuaaID) ON areasofpractice.areasID = memberap.apID where ListDir = 1 AND FirstName like '%' AND LastName like '%' AND (areasID = 4 OR areasID = 5 OR 1=1) ORDER BY LastName, FirstName ASC LIMIT 0,20
Can anyone tell me how to best re-write this query so that it will work on the older MySQL server?
MrsBean