title: MySQL: select distinct names for each date?
body: <p>Say I want to select rows with a date range or date_feild > 2009-06-01 &amp;&amp; date_field &lt; 2009-07-01. and I want to select the first_name_field and last_name_field but I only want the same name (F+L) to show up once per date. So the same name can show up, multiple times as long as their dates are different; but not if the names are on the same date. Does that makes sense? we are trying to track how many inquiries we got over a time period, but if the same user made multiple inquiries on the same day we want to count that as just 1. </p>
  
  <p>I haven't even starting to program this yet so I am open to all suggestions.</p>
  
  <p>Thanks!</p>