PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
I did try removing the word ‘like’ and then got the following which didn’t contain an error but didn’t return all the data in the database for this part of the ‘Search All’
SELECT * FROM teachers,inst_teach,locations,instruments WHERE teachers.contents_IDPK = inst_teach.teacher_IDFK AND inst_teach.instrument_IDFK = instruments.instruments_IDPK AND teachers.counties_IDFK = locations.counties_IDPK AND locations.counties_IDPK = '%' AND instruments.instruments_IDPK = 65 ORDER BY teachers.contents_IDPK
Ok I hope I caught you in time. The problem is solved. I had to replace the " with ' that I origionally had removed in the test a few posts back e.g. "Counties_IDPK\" is now 'Counties_IDPK\' again and all seems to be working ok.
If you go to the same page now and 'Select All' and Select 'Guitar' all the entries in the database are now returned.
Thanks you very much for this invaluable help. It has been a good lesson and one that I have learned a lot from.