Select Query in php

1.  How to compare your email and pwd with your database in login table

       - select * from login where email="$email" and pwd="$pwd"

       - select email,pwd from login where email="$email" and pwd="$pwd" 

     2.  How to select table in column

      

       - select * from table_name

       - select col1,col2 from table_name

     3. How to used select query with order by,limit and ascending order

     

      - select * from table1 order by 'table1','col1' ASC 

      - select * from table1 order by 'table1','col1' DESC

      - select * from table1 order by 'table1','col1' ASC LIMIT 0,30