please vist the link :
my front end is completely with json and html this is not a text box or dropdown box so i dont know how to write the select statement to fetch the data.
this is an example of mu front end
You've got a whole bunch of words in that post, but not an actual question.
How do you get data out of a json? json_decode
How do you put data into a json? json_encode