如何在没有while循环的情况下使用mysql_fetch_array

Question

hey i want to use php mysql_fetch_array to fetch full table data at a time for that i use

while($user_details_result[]=mysql_fetch_assoc($user_details_qr));

but it returns a blank array at last like below

output:

Array
(
    [0] => Array
        (
            [user_id] => 2
            [user_name] => w
            [user_login_id] => w
            [user_login_password] => w
            [user_contacts] => w
            [user_status] => 0
            [user_post_date] => ::1
            [user_post_ip] => 2014-03-07 16:17:59
        )

    [1] => Array
        (
            [user_id] => 1
            [user_name] => q
            [user_login_id] => q
            [user_login_password] => q
            [user_contacts] => q
            [user_status] => 1
            [user_post_date] => ::1
            [user_post_ip] => 2014-03-07 16:14:23
        )

    [2] => 
)

i dont understand why 3 rd row appears..please help

Answer 1

Use this

while($temp=mysql_fetch_assoc($user_details_qr)) {
    user_details_result[] = $temp;
}