I need an app for both iPhone and Android which pulls data from a mysql table. The app needs to identify connected data and graphically display the links. All graphic design etc must also be done.
The app will do:
1 allow users to select a category / group of data from the table (1 column filtered)
2 based on that selection identify what values there are in that group and allow users to select the next value (filtering content in column 2)
3 it will then show a user interface where 2 pieces of meta data from the table in a bubble (graphic) with lines to other bubbles where there is in a column of the table words that equal that line.
For example (to explain 3 better) column I has some words like "this is an example".
Column 4 has words which, if it happens to contain those exact words "this is an example" - then those must be connected in the user interface.
I want a seamless and borderless experience.
I would like it to look like bubbles or clouds with lines connecting the data together.
It must connect all values where column 4 says that there is a connection (there could be 1, 5 10, 20 etc connection).