How do I convert a MySQL query results in a JSON object?

The procedure is quite simple. You run the query, the results are placed in an array that eventually is converted into JSON using the function json_encode ().
Here's an example:

 / / Create an empty array designed to accommodate the query results







 $ Results = array ();









 / / Run the query







 $ Res = mysql_query ("SELECT ...");









 / / Cycle results







 while ($ row = mysql_fetch_assoc ($ res)) {



  



 / / Add to the array ...



  



 $ Results [] = $ row;







 }









 / / Print the results on-screen formatted according to the syntax of JSON

 





 json_encode echo ($ result);