Re: Problem with doubles results

[Corion]

Please post the actual code together with its actual output. The code you posted cannot produce the output you show:

SELECT name country gender FROM tbl_U WHERE location = ?

This is not valid SQL.

{
"info": "\t\t\t\t\t\t  \n<p>John UK Male</p> \n<p>Kieth UK Male</p>"
...

This output cannot be produced by

$json_msg .= <<HTML;                          
<p>$name $country $gender</p>
HTML

... as this line does not contain any tabs.

You may want to learn about scoping and where to put your variable declarations. Or at least think about why you are appending to $json_msg, instead of simply setting it to the desired value.