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

[eluser]TheFuzzy0ne[/eluser]
Here's the output of dprint_r() on the array returned from the database:
Code:
Array
(
    [0] => Array
        (
            [a_id] => 1
            [a_user_id] => 1
            [a_content] => User1's first blog entry.
            [a_title] => Article 1
            [a_created_on] => 2013-01-01 00:00:00
            [a_username] => user1
            [c_comment_id] => 1
            [c_comment] => User2's first comment on User1's first blog entry.
            [c_user_id] => 2
            [c_username] => user2
            [c_created_on] => 2013-01-01 00:00:00
        )

    [1] => Array
        (
            [a_id] => 1
            [a_user_id] => 1
            [a_content] => User1's first blog entry.
            [a_title] => Article 1
            [a_created_on] => 2013-01-01 00:00:00
            [a_username] => user1
            [c_comment_id] => 2
            [c_comment] => User3's first comment on User1's first blog entry.
            [c_user_id] => 3
            [c_username] => user3
            [c_created_on] => 2013-01-01 00:00:00
        )

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

    [3] => Array
        (
            [a_id] => 1
            [a_user_id] => 1
            [a_content] => User1's first blog entry.
            [a_title] => Article 1
            [a_created_on] => 2013-01-01 00:00:00
            [a_username] => user1
            [c_comment_id] => 4
            [c_comment] => User3's second comment on User1's first blog entry.
            [c_user_id] => 3
            [c_username] => user3
            [c_created_on] => 2013-01-01 00:00:00
        )

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

    [5] => Array
        (
            [a_id] => 2
            [a_user_id] => 1
            [a_content] => User1's second blog entry.
            [a_title] => Article 2
            [a_created_on] => 2013-01-01 00:00:00
            [a_username] => user1
            [c_comment_id] => 6
            [c_comment] => User3's first comment on User1's second blog entry.
            [c_user_id] => 3
            [c_username] => user3
            [c_created_on] => 2013-01-01 00:00:00
        )

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

    [7] => Array
        (
            [a_id] => 3
            [a_user_id] => 1
            [a_content] => User1's third blog entry.
            [a_title] => Article 3
            [a_created_on] => 2013-01-01 00:00:00
            [a_username] => user1
            [c_comment_id] => 8
            [c_comment] => User5's first comment on User1's third blog entry.
            [c_user_id] => 5
            [c_username] =>
            [c_created_on] => 2013-01-01 00:00:00
        )

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

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

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

)


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