XTSR Posted January 9, 2018 Share Posted January 9, 2018 So I have made a query to retrieve some results in the database we made for the project but it only returns results when I only search for the first name, it doesn't retrieve results when I search for a last name or a complete name. Disclaimer: I am a novice in PHP and Mysql Here is the query: "SELECT * FROM tblparents WHERE strFirstName LIKE '%{$strSearchMe}%' OR strLastName LIKE '%{$strSearchMe}%'" Quote Link to comment https://forums.phpfreaks.com/topic/306110-how-can-i-make-this-query-work/ Share on other sites More sharing options...
requinix Posted January 9, 2018 Share Posted January 9, 2018 The query certainly seems reasonable. What is the query after inserting the values? What if you run it manually? Quote Link to comment https://forums.phpfreaks.com/topic/306110-how-can-i-make-this-query-work/#findComment-1555160 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.