DataAssist converting ColdFusion to PHP
I'm using DataAssist/PHP to build a site's admin area, but I'm having some trouble with converting some existing code and queries from CF to PHP. This is my first attempt at building a PHP site, by the way, but I want to continue using WA products, so I'm testing the water with PHP.
Current code that is working (ColdFusion/SQL Server database):
<cfquery name="rstContent" datasource="#db#">
SELECT dbo.webContent.webCatID, dbo.webContent.pageID, dbo.webContent.webSubPageID, dbo.webContent.webSubSubPageID, dbo.webContent.[content],
dbo.webPages.pageName, dbo.webSubPages.pageName AS subPageName, dbo.webSubSubPages.pageName AS subSubPageName,
dbo.webContent.pageName AS contentPageName
FROM dbo.webContent LEFT OUTER JOIN
dbo.webSubSubPages ON dbo.webContent.webSubSubPageID = dbo.webSubSubPages.webSubSubPageID LEFT OUTER JOIN
dbo.webSubPages ON dbo.webContent.webSubPageID = dbo.webSubPages.webSubPageID LEFT OUTER JOIN
dbo.webPages ON dbo.webContent.pageID = dbo.webPages.pageID
WHERE (0 = 0)
<cfif IsDefined("url.PageID")>AND webContent.pageID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#URL.pageID#"></cfif>
<cfif IsDefined("url.webSubPageID")> AND webContent.webSubPageID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#URL.webSubPageID#"></cfif>
<cfif IsDefined("url.webSubSubPageID")> AND webContent.webSubSubPageID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#URL.webSubSubPageID#"></cfif>
</cfquery>
This is my PHP code and I have absolutely no idea how to build the conditional statements into the query using PHP. I can't find a good example out there anywhere to use for reference. Can anybody help with this?
Thank you!