Hi all!
Im migrating an MSSQL app to php / mysql and I have to deal with the way the data in MSSQL had been setup. One of the tables has only two columns: objpatid and Localizacion.
objpatid is an indexed integer identification number unique for each object in the database.
Localizacion is the column for every object, its data structured more like a "path" to a physical location in a builduing, a typical row in that column looks like this:
2ND FLOOR \ GENERAL INTENSIVE CARE UNIT \ INTENSIVE CARE UNIT ROOM ONE \ DEFIBRILLATOR
2ND FLOOR \ GENERAL INTENSIVE CARE UNIT \ INTENSIVE CARE UNIT ROOM ONE \ NEGATOSCOPE
I would like to display this in the web page as a treeview, where you have, for example, the floors, 1ST FLOOR, 2ND FLOOR, etc., then as you open 2ND FLOOR it shows the areas in second floor, let's say: GENERAL INTENSIVE CARE UNIT, etc., when you expand that area then shows ... etc.,....
The data is delimited by the " \ " (backslash).
Please, help me understand this or how can I organize this to be able to present it as a treeview.
Thanks!
