NYCPHP Meetup

[Rolan Yang]

Try

$query = mysql_query("SELECT count(*) FROM activeAI WHERE locationID='$locationID' AND activeID <> '$activeID' AND isUndead=0");
list($numOtherAI)=mysql_fetch_row($query);
mysql_free_result($query);


It should conserve memory since MySql will be returning a single integer instead of the entire list of activeID's.

~Rolan
 


jface at mercenarylabs.com wrote:
> After a lot of trial and error I've narrowed down the offending query in my problem with sql results not freeing themselves up:
>
> $query = mysql_query("SELECT activeID FROM activeAI WHERE locationID='$locationID' AND activeID <> '$activeID' AND isUndead=0");
> $numOtherAI = mysql_num_rows($query);
> mysql_free_result($query);
>
> When I comment out this query, the error(s) go away. Variables $locationID and $activeID are both properly set.
>
> Is there something horribly wrong with this query? Is m_f_r() just not working? Too many ANDs?
>
> Jonathan
>
> On Tue, 5 Dec 2006 22:45:34 -0500, Jon Baer <jonbaer at jonbaer.com> wrote:
>   
>> Add a debug_print_backtrace() before the free result or query.  I
>> find it to be very handy in PHP5, although I wish there was a way to
>> dump the results to a UDP port for catching it as well.
>>
>> - Jon
>>
>> On Dec 5, 2006, at 8:39 PM, <jface at mercenarylabs.com>
>> <jface at mercenarylabs.com> wrote:
>>
>>     
>>> I have a very complex app I've been working on currently at about
>>> three thousand lines of code. All of a sudden it started spitting
>>> out the following warning:
>>>
>>> Warning: Unknown: 2 result set(s) not freed. Use mysql_free_result
>>> to free result sets which were requested using mysql_query() in
>>> Unknown on line 0
>>>
>>> So I went through it line-by-line and added a mysql_free_result()
>>> after EVERY query, to no avail.
>>>
>>> The worst thing about this error is that it doesn't give me a valid
>>> line number, so it's impossible to tell exactly where the bad
>>> queries are.
>>>
>>> This is occurring on a php5/mysql5/apache setup.
>>>
>>> Anyone have any suggestions? I'm out of ideas.
>>>
>>> Jonathan
>>>
>>> _______________________________________________
>>> New York PHP Community Talk Mailing List
>>> http://lists.nyphp.org/mailman/listinfo/talk
>>>
>>> NYPHPCon 2006 Presentations Online
>>> http://www.nyphpcon.com
>>>
>>> Show Your Participation in New York PHP
>>> http://www.nyphp.org/show_participation.php
>>>       
>> _______________________________________________
>> New York PHP Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> NYPHPCon 2006 Presentations Online
>> http://www.nyphpcon.com
>>
>> Show Your Participation in New York PHP
>> http://www.nyphp.org/show_participation.php
>>     
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>