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.

thanks, i got it working now