128 results/rows

[sp@rky13]

Ok so, I hadn't noticed this before and I'm unsure if it's new or not????

 

Anyway, so when I do this query:

 

<?php
$con = mysql_connect("*****","********","**********");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("****", $con);
  
$result = mysql_query("SELECT GROUP_CONCAT(CONCAT_WS('|',b.x,b.y) SEPARATOR ' ') AS xy FROM player9 a INNER JOIN village9 b ON a.id = b.player WHERE a.name = 'gianni23' GROUP BY a.id");

if($row = mysql_fetch_array($result))
{
echo $row['xy']; 
}
mysql_close($con);
?>

but then I only get 128 results instead of 497. Why is that? I'v tried using the same query but a different name and the same thing???? I then tried accessing the database using a row by row query and it came up with the 497 results. Why is it doing this?

[sp@rky13]

sorry for not putting it in code boxes. Just noticed but too late too modify

[fenway]

I'm not sure I follow... what makes you think this is incorrect?