If you step over the code you've posted, you're still doing everything inside the foreach. It doesn't make sense to
- Clobber $html rather than append to it.
- Create a json object.
- print a header and the encoded json. The new problem.
for each query result. Use $html .= rather than clobber it. Create json once outside the foreach then print the header and json content once.
Again, it'd be a lot less painful for all concerned if you took the time to read and understand what has been written in replies and read & step thorough your own code since you don't seem to understand what you wrote.
