Welcome Guest, Not a member yet? Register   Sign In
Join Query Help
#13

[eluser]TheFuzzy0ne[/eluser]
And here's the data after I formatted it:
Code:
Array
(
    [1] => Array
        (
            [a_id] => 1
            [a_user_id] => 1
            [a_username] => user1
            [a_created_on] => 2013-01-01 00:00:00
            [a_title] => Article 1
            [a_content] => User1's first blog entry.
            [comments] => Array
                (
                    [0] => Array
                        (
                            [c_id] => 1
                            [c_user_id] => 2
                            [c_username] => user2
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User2's first comment on User1's first blog entry.
                        )

                    [1] => Array
                        (
                            [c_id] => 2
                            [c_user_id] => 3
                            [c_username] => user3
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User3's first comment on User1's first blog entry.
                        )

                    [2] => Array
                        (
                            [c_id] => 3
                            [c_user_id] => 4
                            [c_username] => user4
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User4's first comment on User1's first blog entry.
                        )

                    [3] => Array
                        (
                            [c_id] => 4
                            [c_user_id] => 3
                            [c_username] => user3
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User3's second comment on User1's first blog entry.
                        )

                )

        )

    [2] => Array
        (
            [a_id] => 2
            [a_user_id] => 1
            [a_username] => user1
            [a_created_on] => 2013-01-01 00:00:00
            [a_title] => Article 2
            [a_content] => User1's second blog entry.
            [comments] => Array
                (
                    [0] => Array
                        (
                            [c_id] => 5
                            [c_user_id] => 4
                            [c_username] => user4
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User4's first comment on User1's second blog entry.
                        )

                    [1] => Array
                        (
                            [c_id] => 6
                            [c_user_id] => 3
                            [c_username] => user3
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User3's first comment on User1's second blog entry.
                        )

                )

        )

    [3] => Array
        (
            [a_id] => 3
            [a_user_id] => 1
            [a_username] => user1
            [a_created_on] => 2013-01-01 00:00:00
            [a_title] => Article 3
            [a_content] => User1's third blog entry.
            [comments] => Array
                (
                    [0] => Array
                        (
                            [c_id] => 7
                            [c_user_id] => 4
                            [c_username] => user4
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User4's first comment on User1's third blog entry.
                        )

                    [1] => Array
                        (
                            [c_id] => 8
                            [c_user_id] => 5
                            [c_username] =>
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User5's first comment on User1's third blog entry.
                        )

                    [2] => Array
                        (
                            [c_id] => 9
                            [c_user_id] => 4
                            [c_username] => user4
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User4's second comment on User1's third blog entry.
                        )

                )

        )

    [4] => Array
        (
            [a_id] => 4
            [a_user_id] => 2
            [a_username] => user2
            [a_created_on] => 2013-01-01 00:00:00
            [a_title] => Article 4
            [a_content] => User2's first blog entry.
            [comments] => Array
                (
                    [0] => Array
                        (
                            [c_id] => 10
                            [c_user_id] => 1
                            [c_username] => user1
                            [c_created_on] => 2013-01-01 00:00:00
                            [c_comment] => User1's first comment on User2's first blog entry.
                        )

                )

        )

    [5] => Array
        (
            [a_id] => 5
            [a_user_id] => 3
            [a_username] => user3
            [a_created_on] => 2013-01-01 00:00:00
            [a_title] => Article 5
            [a_content] => User3's first blog entry.
            [comments] => Array
                (
                )

        )

)

Hope this helps.


Messages In This Thread
Join Query Help - by El Forum - 05-28-2013, 07:58 AM
Join Query Help - by El Forum - 05-28-2013, 10:56 AM
Join Query Help - by El Forum - 05-28-2013, 11:39 AM
Join Query Help - by El Forum - 05-28-2013, 11:54 AM
Join Query Help - by El Forum - 05-28-2013, 12:00 PM
Join Query Help - by El Forum - 05-28-2013, 12:00 PM
Join Query Help - by El Forum - 05-28-2013, 12:05 PM
Join Query Help - by El Forum - 05-28-2013, 01:09 PM
Join Query Help - by El Forum - 05-28-2013, 02:42 PM
Join Query Help - by El Forum - 05-29-2013, 04:00 AM
Join Query Help - by El Forum - 05-29-2013, 04:00 AM
Join Query Help - by El Forum - 05-29-2013, 04:00 AM
Join Query Help - by El Forum - 05-29-2013, 04:00 AM
Join Query Help - by El Forum - 05-29-2013, 05:10 AM
Join Query Help - by El Forum - 05-29-2013, 12:35 PM
Join Query Help - by El Forum - 05-29-2013, 12:36 PM
Join Query Help - by El Forum - 05-29-2013, 12:39 PM
Join Query Help - by El Forum - 05-30-2013, 09:23 AM



Theme © iAndrew 2016 - Forum software by © MyBB