sp@rky13 Posted November 13, 2009 Share Posted November 13, 2009 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? Link to comment https://forums.phpfreaks.com/topic/181350-128-resultsrows/ Share on other sites More sharing options...
sp@rky13 Posted November 13, 2009 Author Share Posted November 13, 2009 sorry for not putting it in code boxes. Just noticed but too late too modify Link to comment https://forums.phpfreaks.com/topic/181350-128-resultsrows/#findComment-956674 Share on other sites More sharing options...
fenway Posted November 14, 2009 Share Posted November 14, 2009 I'm not sure I follow... what makes you think this is incorrect? Link to comment https://forums.phpfreaks.com/topic/181350-128-resultsrows/#findComment-957458 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.