[SOLVED] very very simple.

[ok]

php brotherhood.

 

I have this very simple codes below i don't know whats causing the problem.

 

$query = "UPDATE users SET date_check=now() WHERE date_check='0000-00-00 00:00:00'";

 

this is the error

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/joealex3/public_html/closedb.php on line 4	

 

I think it's the now() causing the problem.

 

Thank you very much in advance for your help..

 

 

[ratcateme]

that looks more like a php error not a query error.

 

Scott.

[JasonLewis]

Did you actually run mysql_query on $query?

[abdfahim]

when you execute your query, do that like the following

$result=mysql_query($query) or die(mysql_error());

 

if you have any sql error, it will show you. In your post, the generated error is saying some problem in the line where you use mysql_free_result(). you better post the whole section of the code.

 

[ok]

i got it. it's the closedb.php

 

that's causing problem.

 

problem solved.

 

THANK YOU GUYS for your concern.

[melon]