- 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
