Hi All, I've checked some of my queries, it seems that it happens when the returned result is only 1 record. Do you guys think this is a problem?
Regards, Martin On Thu, Aug 21, 2008 at 10:45 AM, Daniel Israel <[EMAIL PROTECTED]> wrote: > > On Aug 20, 2008, at 11:19 PM, Martinus Hadiwinata wrote: > > > Hi Guys, > > > > I got this warning on several page: > > *Warning*: mysql_free_result(): 25 is not a valid MySQL result > > resource > > > > Does anyone know how to get rid this warning message that appears on > > a page > > without using error_reporting() function? > > > > I have checked my syntax and they seem fine and correct. Moreover, > > the page > > displays the items as it should be. > > > > Thanks for any help :) > > What kind of query is it happening on? Couple things to make sure of: > > 1. Make sure you're using a query that returns a result. Example, > "SELECT * FROM Table" will return a valid result, but "DELETE FROM > Table WHERE id=16" will return TRUE (success) or FALSE (not success) > which is not a valid result (and would cause your warning). > > 2. If you do have something that should return a result, make sure you > are retrieving something before freeing it. If you call "SELECT * > FROM Table WHERE id=16" and id of 16 doesn't exist, the result will be > FALSE and throw an error on free. > > -D. Israel > [EMAIL PROTECTED] <dan%40ebji.org> > http://www.customcodebydan.com > AIM: JudoDanIzz > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
