How Can I access the first result?
<pre><code>    $tmp = mysql_query("SELECT commercial FROM Channels WHERE name='".mysql_real_escape_string($_POST['name'])."'");
    while( $row = mysql_fetch_assoc($tmp))
    {
     echo $row['commercial'];
    }
</code></pre>

<p>I only want to access the first element.
not in a while loop</p>
