thanks so much, very good and clean answer

its now working. i was printing the $html outside the foreach loop, am now printing $html inside the foreach loop and its working

Can i have a solution for this

am getting results like this :

i want to return the whole data to single json like:

my $sth = $dbh->prepare("SELECT 
  snd.name, snd.country, m.item, m.eqty, m.price, m.line, m.prodct FRO
+M
  buys as m
  JOIN Busers as snd ON snd.id = m.buyer WHERE CASE WHEN (SELECT SUM(s
+tatus = ?) FROM  buys) > 0 THEN m.status = ? ELSE m.status = ?  OR m.
+status = ? OR m.status = ? END
  ORDER BY created ASC");
$sth->execute('sold', 'forsell', 'bugt', 'paid', 'inshop');
my $Data = $sth->fetchall_arrayref();

foreach my $Data (@$Data) {
    
    my ($name, $country, $item, $eqty, $price, $line, $prodct) = @$Dat
+a;
    
    $html = "<tr>
    <td>
        
            <p>$name</p>
        
       
        <p>
            
            $eqty, $price, $line,
        </p>
        
            $prodct
       
            $country
        </td>
</tr>
";

my $json = encode_json(
  { msg => $html}
);

print $q->header( -type => 'application/json' ),$json;

}
[download]

This is because you didn't actually fix the problem earlier (while making it worse), and ignored the working example, hippo gave you.

hippo example was hard for me to figure it out, according to what i want