title: How to use Zend Adapter to retrieve information from database
body: <p>I'm trying to figure out the essentials of Zend Adapter. The tutorials and explanations are confusing and needs more clarification. Can someone give me simple examples to fully understand how to work with SQL queries and how to get the desired SQL results?</p>
  
  <p>especially, I'm interested in learning how to get </p>
  
  <p>-- column names</p>
  
  <p>-- table names </p>
  
  <p>-- fetchAll entries</p>
  
  <p>and etc.</p>
  
  <p>Thank you,</p>