Re: Input Query string from a file

[Douglas Moxley]

Hi PB,


I've tried hundreds of combinations to get the below variable to populate in my SELECT statement with no success. Always comes up empty. If I manually enter an employee name it retrieves all data from the database. I'm referring to the second line that says lname = $gfile ');. I've tried with different quotes but the variable doesn't work. Thank you very much for any assistance you can provide!!!!


1. $qfile = "qfile.txt";


2. $result = mysqli_query ($dbLink, 'SELECT fname, lname FROM ticket_tbl WHERE lname = $qfile ') ;


3. $row = mysqli_fetch_array($result);