Problem with doubles results

[frank1]

This node falls below the community's threshold of quality. You may see it by logging in.

[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.

[NERDVANA]

You declared my %hash outside of the loop, so each time you push @updated_data, \%hash you get a reference to the same hash. So, it will be an array of many references to the final value of the hash on the last loop iteration.

Declare my %hash inside the loop to get a new one each time.