A PHP Error was encountered

[eluser]John_Betong[/eluser]
[quote author="jiahui" date="1258705983"]This is the result list I got:

Code:

Name   ==> [b]missing_$data_name[/b]
Type   ==> array(10)
Count  ==> 10
Value  ==>

Array
(
    [0] => stdClass Object
        (
            [id] => 12
            [username] => ddd.ddddddd
            [password] => UGNSPwEzBzdSZQ1pBWVTPQ==
            [ip_address] => ::1
            [groupid] => 3
            [firstname] => ddd
            [lastname] => dddddd
            [email] => [email protected]
            [phone] =>
            [last_login] => 0000-00-00 00:00:00
            [banned] => 0
        )

    [1] => stdClass Object
        (
            [id] => 8
            [username] => ee.eeee
            [password] => eeeeeeee
            [ip_address] => ::1
            [groupid] => 1
            [firstname] => ee
            [lastname] => ee
            [email] => [email protected]
            [phone] =>
            [last_login] => 0000-00-00 00:00:00
            [banned] => 0
        )
...
...
)

Could tell me what is the indeed problem caused this error msg appearing all the times?

Code:

A PHP Error was encountered

Severity: Warning

Message: Unknown: 2 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()

Filename: Unknown

Line Number: 0

[/quote]
 
Please note that the error message returned is not an error it is a warning. You could hide the warning by changing the error level setting.

I would be tempted to exactly pinpoint where the message is appearing and then take steps to free the result set by using $result->free_result();.

Normally the result set is freed automatically but it appears to be some sort of conflict. To eliminate this I would free the result set every time immediately after I have stored the result set.