mysql query 'GROUP_CONCAT' - need help

[carlosp]

here's what i want to do:

i have a table which has id's and i want to select them in one query, then put them in an array...

 

table example:

id                  name          surname

1                  john              doe

2                 johnny          tacev

.

.

19384          travis          malega

 

i tried this:

$query = "SELECT GROUP_CONCAT(id) AS id_coll FROM table ORDER BY id DESC";

$result = mysql_query($query) or die ("no query");

while($row = mysql_fetch_assoc($result))
{    $cs = implode(", ", $row);

}

 

it works but only for the first 256 rows... i can't change server settings...

 

please help me with this

 

thanks!

 

PS: i hope i posted in the right section

[carlosp]

here's what i want to do:

i have a table which has id's and i want to select them in one query, then put them in an array...

 

table example:

id                  name          surname

1                  john              doe

2                 johnny          tacev

.

.

19384          travis          malega

 

i tried this:

$query = "SELECT GROUP_CONCAT(id) AS id_coll FROM table ORDER BY id DESC";

$result = mysql_query($query) or die ("no query");

while($row = mysql_fetch_assoc($result))
{    $cs = implode(", ", $row);

}

 

it works but only for the first 256 rows... i can't change server settings...

 

please help me with this, it doesn't matter if i need to change the query in any other way. i just need to have the id's in an array (1,2,3,......,19384)

 

thanks!

 

PS: i hope i posted in the right section

[haku]

You don't need GROUP_CONCAT for this. Just select ID normally, then loop through the results and put them into an array.

[Psycho]

But, the reason you are having a problem is that you are using GROUP_CONCAT() but you don't have a GROUP BY to group on.

[Barand]

By row 256 you have probably hit the 1000 char size limit

[carlosp]

thank you all for replying, could you please give me an example of selecting all the id's and put them into an array?

one which works, because i couldn't build one until now....

[Psycho]

$query = "SELECT id FROM table ORDER BY id DESC";

$result = mysql_query($query) or die ("no query");


$idsArray = array();

while($row = mysql_fetch_assoc($result))

{

    //Add each ID as a new element in the array

    $idsArray[] = $row['id'];

}


//Output the array to verify

echo "<pre>" . print_r($idsArray, 1) . "</pre>";

Edited March 24, 2013 by Psycho

[carlosp]

thanks for your reply's

just fixed this morning the query...