error with - mysql_free_result()

[JustKIDn]

Hi all,

After a series of pages that all work correctly. I am getting this error;

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/httpd/html/phone/modify.php on line 78

This is the code that errors that is in all the other pages that work correctly;

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($dbcnx);


The only big difference I see, is all the other pages are doing SELECT statements. And on this page I am doing an UPDATE.

Is it not possible to use mysql_free_result() with UPDATE? Why not?


tgus

____________________________
Families can be together forever...

 

[danielhozac]

UPDATE

queries don't return a result set, hence the result only tells you if the operating was successful or not and isn't a result resource.

//Daniel

 

[JustKIDn]

Is that true for INSERT and DELETE also?

Thanks for the help!


tgus

____________________________
Families can be together forever...

 

[danielhozac]

Yes.

//Daniel