| Server IP : 104.21.21.239 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/nympadmin/ |
Upload File : |
<cfquery name="Ger" dataSource="#ds#"> select id,name,region, advertiser from ParentsListings where advertiser > 0 order by advertiser </cfquery> <table border="1" cellpadding="4" cellspacing="0"> <cfoutput query="Ger"> <Cfquery name="checker" dataSource="#ds#"> select id from ParentsListingsCat2011 where pkid = #ger.id# </cfquery> <Cfif #checker.recordcount# eq 0> <Tr><td> <a href="http://nymetroparents.com/listingseditpk.cfm?id=#id#&table=ParentsListings&cat=0&catid=0">#name#</a> </td><td><Cfif #region# is not 0>#region#</Cfif></td><td><cfif #advertiser# eq '1'>Premium Plus</cfif><cfif #advertiser# eq '3'>Basic</cfif><cfif #advertiser# eq '2'>Premium Light</cfif> </td> <Td> <cfquery name="Getold" dataSource="#ds#"> select catname from ParentsListingsCatMain inner join ParentsListingsCat on ParentsListingsCatMain.id = ParentsListingsCat.catid where ParentsListingsCat.pkid = #ger.id# </cfquery> <cfloop from ="1" to="#getold.recordcount#" index="i"> #getold.catname[i]# <cfif #i# is not #getold.recordcount#> | </cfif> </cfloop> </Td> </Tr> </Cfif> </cfoutput> </table>