How can I featch result from xml through php?

[bccsergio]

I have following XML String. I want to fetch particular result from this XML which is dynamically changed through selection. \[code\]<response uri="/crm/private/xml/Campaigns/getMyRecords"> <result> <Campaigns> <row no="1"> <FL val="CAMPAIGNID">536661000000249003</FL> <FL val="SMOWNERID">536661000000051003</FL> <FL val="Campaign Owner"> <![CDATA[gunjan.sharma]]> </FL> <FL val="Campaign Name"> <![CDATA[Test Campaign]]> </FL> <FL val="Status"> <![CDATA[Active]]> </FL> <FL val="Expected Revenue"> <![CDATA[0]]> </FL> <FL val="Budgeted Cost"> <![CDATA[0]]> </FL> <FL val="Actual Cost"> <![CDATA[0]]> </FL> <FL val="SMCREATORID">536661000000051003</FL> <FL val="Created By"> <![CDATA[gunjan.sharma]]> </FL> <FL val="MODIFIEDBY">536661000000051003</FL> <FL val="Modified By"> <![CDATA[gunjan.sharma]]> </FL> <FL val="Created Time"> <![CDATA[2012-05-14 20:33:56]]> </FL> <FL val="Modified Time"> <![CDATA[2012-05-14 20:33:56]]> </FL> <FL val="Campaign No"> <![CDATA[TCam002]]> </FL> <FL val="Campaigns Source"> <![CDATA[Share Junction]]> </FL> </row> <row no="2"> <FL val="CAMPAIGNID">536661000000198011</FL> <FL val="SMOWNERID">536661000000051003</FL> <FL val="Campaign Owner"> <![CDATA[gunjan.sharma]]> </FL> <FL val="Campaign Name"> <![CDATA[Share Junction]]> </FL> <FL val="Status"> <![CDATA[Active]]> </FL> <FL val="Expected Revenue"> <![CDATA[0]]> </FL> <FL val="Budgeted Cost"> <![CDATA[0]]> </FL> <FL val="Actual Cost"> <![CDATA[0]]> </FL> <FL val="SMCREATORID">536661000000051003</FL> <FL val="Created By"> <![CDATA[gunjan.sharma]]> </FL> <FL val="MODIFIEDBY">536661000000051003</FL> <FL val="Modified By"> <![CDATA[gunjan.sharma]]> </FL> <FL val="Created Time"> <![CDATA[2012-05-07 21:43:33]]> </FL> <FL val="Modified Time"> <![CDATA[2012-05-07 21:43:33]]> </FL> <FL val="Campaign No"> <![CDATA[CAM01]]> </FL> <FL val="Campaigns Source"> <![CDATA[Share Junction]]> </FL> </row> </Campaigns> </result></response>\[/code\]I want to get row where Campaign No = CAM01. How can I?I just want to run this type of query\[quote\] select CAMPAIGNID from Campaigns where Campaign No = '$val' \[/quote\]is it possible?