[Antivirus]

thanks Amy, i still can't figure it out though - until i can, this should be a work around, however i know it should be able to make it happen- just neeed to work on it......

PHP Code:

    if ($_GET['contenttypeid'])
    {
        $querycontents = $db->query_read("
                        SELECT erc_content.*, erc_contenttype.contenttype
                        FROM erc_content
                        LEFT JOIN erc_contenttype ON erc_content.contentid = erc_contenttype.contenttypeid
                        AND erc_content.contenttypeid = '".$_GET['contenttypeid']."'
                        ORDER BY erc_contenttype.displayorder, erc_content.displayorder
                        ");
    }    
    else
    {
        $querycontents = $db->query_read("
                        SELECT erc_content.*, erc_contenttype.contenttype
                        FROM erc_content
                        LEFT JOIN erc_contenttype ON erc_content.contentid = erc_contenttype.contenttypeid
                        ORDER BY erc_contenttype.displayorder, erc_content.displayorder
                        ");
    }