get an array, or a list as a result, in a field

[[deleted]]

i'd like to get an array, or a list of data
separated by commas when making a query which retrieves data from a table related to another table

if i perform (for eg.)

SELECT t1.id AS parent_id, t1.name, t2.id AS child_id, t2.name
FROM parents AS t1, childs AS t2
WHERE t2.parent = t1.id

then i'll get as many rows as childs they have for each parent.
i'll get, for eg.,

"1" - "john" - "8" - "mary"
"1" - "john" - "3" - "jack"

and i'd like to get

"1" - "john" - "8,3" - "mary,jack"

so i can explode them on php to arrays

i haven't found the way to perform the query right using the CONCAT() function and the GROUP BY clause

i already thank u! 😉

[wilsonodk]

If using MySQL you could do this

// SQL Statement
$sql = "SELECT t1.id AS parent_id, t1.name, t2.id AS child_id, t2.name FROM parents AS t1, childs AS t2 WHERE t2.parent = t1.id";

// Query
$result = $mysql_query($sql);

// Do something useful with result
while ($row = mysql_fetch_array($result)) {
// Now the values are in an associative array
// or you could use numeric keys, like this
echo $row['id'];
echo $row[0];
}

There are similar functions for all the supported DBs.

HTH

[[deleted]]

i know how to perform and use results of mysql queries in php, thanks anyway,
what i wanted is a result looking like this

$result=mysql_query($the_magic_sql_query);

$row=mysql_fetch_array($result);

and magically get something like this:

$row[parent_name] == "john"
$row[parent_id] == 1
$row[how_many_children] == 2
$row[child_id][0] == 8
$row[child_id][1] == 3
$row[child_name][0] == "mary"
$row[child_name][1] == "jack"

you know what i mean? i want arrays, but in some array items i want array's arrays (subarrays?)

if i can't get that from mysql (i'm sure i can't)
i'd like to get something like

$row[parent_name] == "john"
$row[parent_id] == 1
$row[child_ids] == "8,3"
$row[child_names] == "mary,jack"

that'd be great cause y can perform:

$child_ids=explode(",", $row[child_ids]);
$how_many_childs=str_count(",", $row[child_ids]);

NOW I GOT $how_many_childs == 2, $child_ids[0]=="mary" AND $childs[1] == "jack" !!!!! JUST WHAT I WANTED !!!

... but i can't perform that CONCAT-GROUPBY-looking query

all this is to avoid the neanderthal-like method:

$result_parent=mysql_query("SELECT * FROM parents");
while($row_parent=mysql_fetch_array($result_parent))
{
// all echoes and all the stuff
// ...

// the multiple result part....
$result_child=mysql_query("SELECT * FROM children WHERE parent_id=" . $row_parent[id]);
while($row_child=mysql_fetch_array($result_child))
{
// all this parent's children info
}
}

that'd be owful!!! query of a query result???? why should i??