Answered
PHP and Spry
Prior to XML I used to simply use PHP to execute a MySQL
query, get the result and do something with it. Sometimes this
would mean I could evaluate the returning value and, depending on
its parameters, I could do something; like not display it. How can
I do this with an XML dataset?
My current issue: I am querying the database for address info. There are 2 fields, address1 and address2. Not every record has a value in address 2 - so if I simply drag out the data elements onto the app, and there is no value, the result is a null line. It would look like this:
FirstName LastName
123 Some Road
SomeCity CA, 99999
When I want this if there is no value in address2:
FirstName LastName
123 Some Road
SomeCity CA, 99999
Prior to utilizing the XML, I would simply evaluate the returned data element using php, but I don't know how, or if, php can evaluate a returning xml value.
Thanks for any help - and if I am missing something that is really obvious; sorry.
-jacob
My current issue: I am querying the database for address info. There are 2 fields, address1 and address2. Not every record has a value in address 2 - so if I simply drag out the data elements onto the app, and there is no value, the result is a null line. It would look like this:
FirstName LastName
123 Some Road
SomeCity CA, 99999
When I want this if there is no value in address2:
FirstName LastName
123 Some Road
SomeCity CA, 99999
Prior to utilizing the XML, I would simply evaluate the returned data element using php, but I don't know how, or if, php can evaluate a returning xml value.
Thanks for any help - and if I am missing something that is really obvious; sorry.
-jacob
