[nyphp-talk] freeing sql results

2006-12-05 Thread jface
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 Unkno

Re: [nyphp-talk] freeing sql results

2006-12-07 Thread jface
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); m

Re: [nyphp-talk] freeing sql results

2006-12-07 Thread jface
I did include "or die()"s, just neglected to put them into the email. No SQL syntax errors come back. The only kinds of errors I'm getting are that sql results are not being freed. Tried passing the SQL into mysql_query as a separate string, too. No luck. On Thu, 07 Dec 2006 22:34:04 -0500, Ken

Re: [nyphp-talk] displaying dates in php

2006-12-25 Thread jface
Your code displays fine for me. You can grab the data after the form has been submitted as POST data. After the form is submitted, the selected values will be stored like: $month = $_POST['month']; $year = $_POST['year']; echo $month . "" . $year; etc, etc Don't forget to add in your opening