PHP - Select a unique mysql line without while
<p>I want to select only unique values with php/mysql. </p>

<p>I can do it with many line, but I forget how to do it without while... :)</p>

<p>Thanks a lot.</p>

<p>Here is the code that I want to do without while.</p>

<pre><code>$request_1m = "SELECT date1, date2 from mytable";

$result_1m = mysql_query($request_1m,$db);

while($row = mysql_fetch_array($result_1m))
{
    /* Get the data from the query result */    
    $date1_1m = $row["date1"];
    $date2_1m = $row["date2"];  
}
</code></pre>
