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
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> 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
_______________________________________________
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
