title: How can I echo a COUNT query
body: <p>I'm new to mySQL and as such am just looking for a very simple COUNT query which I haven't found explained online with any real clarity.</p>
  
  <p>What I'm looking to do is</p>
  
  <p>COUNT the number of rows in my PASSENGER table where groupID = 0, and then be able to echo the numerical value that the count will return, how can I do this?</p>