> Does anyone have any idea why this is giving me a "Warning: Supplied
> argument is not a valid MySQL result resource in..." error?
You'll have to give more code, which line you get that error from, etc., to
give us a better idea why it's "not working."
However, a quick tip:
> $crdate = date("Y-m-d");
> $result = mysql_query("SELECT * FROM sites WHERE creation_date = '$crdate'
> AND status = 'T'");
These two lines can be condensed since MySQL has a built-in function to get
the current time/date:
SELECT * FROM sites WHERE creation_date = NOW() AND status = 'T'
-Adam
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
