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}%'" Link to comment 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.