<Cfif parameterexists(url.listid)>
     <cfquery name="getmembers" datasource="#ds#">
        select phplistdbnew.phplist_user_user.email 
        from phplistdbnew.phplist_user_user
        inner join phplistdbnew.phplist_listuser on phplistdbnew.phplist_listuser.userid = phplistdbnew.phplist_user_user.id
        where phplistdbnew.phplist_user_user.blacklisted = 0 
        and 
        phplistdbnew.phplist_listuser.listid = #url.listid#
        group by email
    </cfquery>
    
<Cfsavecontent variable="myExcelFile">
email
<cfoutput query="getmembers">
#email#
</cfoutput>
</table>
</CFSAVECONTENT>


<cfheader name="Content-Disposition" value="inline; filename=phpcsv/#url.listid#.csv">
<cfcontent type="application/vnd.ms-excel"><cfoutput>#myExcelFile#</cfoutput>

<Cfabort>


<cfsavecontent variable="saveme"><cfcontent type="application/vnd.ms-excel">email<cfoutput query="Getmembers">#email#</cfoutput></cfsavecontent>

<cffile action            = "WRITE" file="/home/home2/cgny/public_html/newadmin/phpcsv/#url.listid#.csv" output="#saveme#">
    <cflocation url           = "phpcsv/#url.listid#.csv">               

<cfelse>

<cfquery name="geter" datasource="#ds#">
SELECT * FROM phplistdbnew.phplist_list
order by category, name
</cfquery>

<table border="1" cellpadding="4" cellspacing="0">
    
    <cfoutput query="geter">
        <tr>
            <td>
                <a href="phpexport.cfm?listid=#id#">view</a>
            </td>
            <td>
                #name#
                
            </td>
            <Td>
                #category#
            </Td>
            
        </tr>
        
        
    </cfoutput>
    
    
</table>

</cfif>