DataAssist converting ColdFusion to PHP

[sandy170299]

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!

[Ray Borduin]

Do you have DataAssist? The easiest way to get a dynamic where clause without hand coding is to use DataAssist search.

You could also hand code if statements and build the query dynamically if you want to write php by hand the same way you did the php.

[sandy170299]

Thanks, Ray. I'll see if I can figure it out with DataAssist Search. I usually just hand code this kind of stuff with ColdFusion. Is there any resource that you know of that could help me figure out how to do this by hand with PHP? The entire language doesn't make any sense to me at this point - I've never worked with PHP before and have no idea where to start...