Best way to handle One-To-Many resultset

[bilibytes]

Hi,

I have a database with a one to many relationship and i was wondering what was the best way to parse the resultset.

this post explains exactly what my situation:
http://stackoverflow.com/questions/5...o-many-results

I don't have PDO neither MySQLi

So if you go to the post, you'll see that there are 2 solutions.

the first solves the problem in MySQL with Concat()
and the second solves it in PHP. it puts if() conditions in a while() loop.

I would finally like an array like this:

$elements = array(
                                  0=>array(
                                         'url_id'=>'id_1',
                                         'categories'=> array(
                                                             0=>'category1',
                                                             1=>'category2'
                                                              )
                                         )
                                  1=>array(
                                         'url_id'=>'id_2',
                                         'categories'=> array(
                                                             0=>'category1',
                                                             1=>'category2'
                                                              )
                                         )
                                  ...
                               )
 

As you can see i don't want to concat. If i used concat() in MySQL i would then have to explode the string.
but i woudn't have to put conditions in my while() loop.

What do you think would be faster?

If you have any experience doing it,
please let me know it would save my some time in testing

Thank you very much

Regards

[wizardry]

you will want to use concat on both the app and database. how ever if you have the option to use functions, procedures, triggers on your server then to answer your next question the app will run faster if its coded into the database.

but their is only so much you can do with mysql database. I love oracle!

i will give you this much: a true web application is ran from the database and vice versa.

hope this helps!

[bilibytes]

thanks for your answer,

but i have to admit i dont really understand what you mean.

why should i concat on both sides (in database and in the app)?

if i concat in the database then there is nothing to concat in the app...?

i mean if i have many records and use concat() AS concatenatedRows, i then get something like this:

while($row = mysql_fetch_array(...)){
   ( $row['url_id'] == 'id1'
    $row['concatenatedRow'] == 'row1 row2 row3 row4')
 
    $rowsArray[] = $row;
}

and here there is nothing to concat, i would need to explode the 'concatenatedRow' string to get what i want:

while($row = mysql_fetch_array(...)){
   ( $row['url_id'] == 'id1'
    $row['concatenatedRow'] == 'row1 row2 row3 row4')
    $row['concatenatedRow'] = explode(' ', $row['concatenatedRow'])
    $rowsArray[] = $row;
}

thus getting the array i showed you in my first post.

so i don't understand what you would like to concat.

However i would be pleased to know what you mean.

thank you again


bilibytes