PHP PDO Modify Search to include two conditions

PHP
3

This query (for example):

SELECT id, last_name, first_name, middle_name, suffix, precinct, 
residential_address 
FROM members WHERE last_name LIKE "brown" AND first_name LIKE "angela"

makes this result in phpMyAdmin:

image
image274×103 4.94 KB

This line of the code makes the output for my application:

if($result) {
			foreach ($result as $row) {
			   echo "<p>{$row['id']} - {$row['last_name']}, {$row['first_name']} 
{$row['middle_name']} {$row['suffix']} ({$row['precinct']}) | 
{$row['residential_address']}</p>";
			}
		} else {
            echo "<p>No records found</p>";
        }

My code will always make the last_name, first_name output, yes.