How to get PHP script to display list content by category type
<p>For my first php effort can to input and display addresses and descriptions of available housing . Now trying to break out/display by housing category type, i.e. House, Apt, Duplex, Condo.  All info is in same table. I have a row called Category, with corresponding values of 1, 2, 3, 4, that I hope to use as the category types.
I'm struggling with the manual and would appreciate any guidance.
Many thanks for your time and assistance.</p>

<p>Below is what I'm currently using to display the entire list.</p>

<pre><code>while($res=mysql_fetch_array($result))
{
    echo "&lt;tr&gt;";    
    echo "&lt;td valign=\"top\" class='address' width=\"180\" colspan=\"3\"&gt;".$res['address']."&lt;/td&gt;";
    echo "&lt;/tr&gt;";
    echo  "&lt;tr&gt;";
    echo "&lt;td valign=\"top\"  class='text_box' width=\"420\" colspan=\"3\"&gt;".$res['desc1']."&lt;/td&gt;";
    echo "&lt;/tr&gt;";
    echo  "&lt;tr&gt;";
    echo "&lt;td valign=\"top\" align=\"left\"  class='text_box' width=\"100\"&gt;".$res['bds']."&lt;/td&gt;";
    echo "&lt;td valign=\"top\"  align=\"left\" class='text_box' width=\"100\"&gt;".$res['bath']."&lt;/td&gt;";
    echo "&lt;td valign=\"top\"  align=\"left\" class='text_box' width=\"412\"&gt;&lt;/td&gt;";
    echo "&lt;/tr&gt;";
}
echo "&lt;/table&gt;";
</code></pre>
