title: Mysql VIEWS vs. PHP query
body: <p>I am working on a web application which involves create list of Restaurants in various lists like "Joe's must visit places". Now for each Restaurant and list, I have display on website which calculates</p>
  
  <ul>
  <li>Calculating popularity of a Restaurant</li>
  <li>Popularity of a list</li>
  <li>Number of lists a Restaurant is present in</li>
  </ul>
  
  <p>Currently I am using MySQL statements in PHP for this but planning to switch to MySQL VIEWS and do a simple select statement in PHP...</p>
  
  <p>my question is,
  <strong>What is Advantage/Disadvantage of using VIEWS over writing sql queries in PHP?</strong></p>