We can use the end operator to filter records using multiple conditions.
Let's say for example we want to display all the e-mail records in our database where the first name
is equal to Ted and the last name is equal to King to do so.
Replace your existing Eskew query with this line
here we've created a select statement to select the email column from our users table where first name
is equal to Ted.
And so we have a second condition.
The last name is equal to King now.
Let's update our echo statement as well because we want to output the email and not the first name.
Looking at our database we know for a fact that there is no record where the first name is equal to
Ted and the last name is equal to King if the only record we have is first named Ted in last name Smith
So when we refresh our page it should say zero results.
And it does.
Now let's say for example we were to change the last name to Smith.
Now we know that these two conditions will be met.
There is a record where the first name is Ted and the last name is Smith So if we press refresh it outputs
that one result.
That's that's the email address linked to that record so it found the record where both these conditions
were met.