Multiple results + Array displays
<p>this query matches with two fields in the database. How can i grab both of the names from the DB?</p>

<pre><code>        $product_q = mysql_query("SELECT * FROM `templates` WHERE `cat_id` = '$catid'") or die("&lt;br/&gt;&lt;br/&gt;".mysql_error());
        $product_array = mysql_fetch_array($product_q);
        $product_name = $product_array['name']; //got the first results 'name'
        $product_name2 = $product_name[1]; // attempted to get the 2nd 'name'.
</code></pre>
