MySQLi -> How to select only one item from the list

Hi,

I have a serious problem. The bellow code select every thing from the column email:

if ($result = $mysqli->query("SELECT email FROM users ORDER BY 1"))

Code (markup):

It's ok if the conditional statement is matched. But it returns all over 2 thousands of my users emails as not found if there is no email is matched with which stored in the database. I've changed code as bellow:

if ($result = $mysqli->query("SELECT email FROM users WHERE email = $email"))

Code (markup):

It does not work.

Thanks in advance

 

Never mind I can managed to get it worked.