I searched the board and found some old code in the ASPrunner forum... but, it did not work.
I have two tables (properties and documents).
PROPERTIES TABLE - FIELD "icon"
[{"name":"files\/icon-angelfire_rirtanh2.png","usrName":"icon-angelfire.png","size":1359,"type":"image\/png","thumbnail":"files\/thicon-angelfire_4sjavl61.png","thumbnail_type":"image\/png","thumbnail_size":1359,"searchStr":"icon-angelfire.png,!:sStrEnd"}]
DOCUMENTS TABLE - FIELD "documents"
[{"name":"files\/Covey Call Count Data Sheet_9yj21k6l.pdf","usrName":"Covey Call Count Data Sheet.pdf","size":63090,"type":"application\/octet-stream","searchStr":"Covey Call Count Data Sheet.pdf,!Bird Sampling for Research Lab.docx,!Fall Covey Counts.pdf,!Helicopter Counting for Quail.pdf,!:sStrEnd"},{"name":"files\/Bird Sampling for Research Lab_d0enyee2.docx","usrName":"Bird Sampling for Research Lab.docx","size":15769,"type":"application\/vnd.openxmlformats-officedocument.wordprocessingml.document"},{"name":"files\/Fall Covey Counts_hdhtb5s7.pdf","usrName":"Fall Covey Counts.pdf","size":69069,"type":"application\/octet-stream"},{"name":"files\/Helicopter Counting for Quail_lhedhm4c.pdf","usrName":"Helicopter Counting for Quail.pdf","size":2006470,"type":"application\/octet-stream"}]
This is how PHPrunner stores the data in the fields (see above).
I'm trying to do two things.
On my website I want to pull the image (field "icon") of the property.
[icon] lorem ipsum
On my website I want to have a page called "document library" and I want to pull the documents. So, on that page it would look like this...
Research Papers by Robert
- thisfile.doc
- thatfile.pdf
- anotherfile.xls
(see in this second scenario there are multiple files uploaded to the field "documents")
I'm at a loss...