RE: [PHP] my query results won't clear!! :(

> -----Original Message----- > From: Sandeep Hundal [mailto:Sunny@mviva.net] > Sent: Monday, May 14, 2001 9:13 AM > To: Mark Roedel; Sandeep Hundal; php-general@lists.php.net > Subject: RE: [PHP] my query results won't clear!! :( > > > damn, yeah thats my problem. how do i clear out all variables then?? Try unset(). http://php.net/manual/en/function.unset.php --- Mark Roedel (roedelm@letu.edu) || "There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full." LeTourneau University || -- Henry Kissinger > -----Original Message----- > From: Mark Roedel [mailto:MarkRoedel@letu.edu] > Sent: 14 May 2001 14:56 > To: Sandeep Hundal; php-general@lists.php.net > Subject: RE: [PHP] my query results won't clear!! :( > > > > -----Original Message----- > > From: Sandeep Hundal [mailto:Sunny@mviva.net] > > Sent: Monday, May 14, 2001 3:21 AM > > To: php-general@lists.php.net > > Subject: [PHP] my query results won't clear!! :( > > > > > > i'm running a select query on a table, and ihave a form right > > underneath it, with similar names to the information selected > > in the query above. > > > > yet despite using mysql_free_results before my form starts, it > > still keeps the last result of the query 1 in memory :( > > > > are there any solutions?? > > It's hard to be certain of much without seeing any of your code. > > My guess, though, would be that you're simply misunderstanding the > extent to which mysql_free_result() operates. > > In particular, it only frees the memory associated with the result set > itself. It does not clear out variables that you've assigned to hold > pieces of the returned data. > > That is, given the following code: > > $result = mysql_query('select * from table'); > $mydata = mysql_fetch_array($mydata); > mysql_free_result($result); > > $result should be cleared out. $mydata, however, should be retained. > > Does that match what you're experiencing?