MySQL error... but it works!!??
| From: | Simon Kimber | Date: | Sat, 05 Jan 2002 20:49:55 +0000 |
| Subject: | MySQL error... but it works!!?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-79573@lists.php.net to get a copy of this message | ||
Does anyone have any idea why this is giving me a "Warning: Supplied
argument is not a valid MySQL result resource in..." error?
The funny thing is that apart from that error message it works perfectly!!
---------------------------
$crdate = date("Y-m-d");
$result = mysql_query("SELECT * FROM sites WHERE creation_date = '$crdate'
AND status = 'T'");
while ($sitedata = mysql_fetch_array($result)) {
echo $sitedata['name'] . "<br>";
}
---------------------------
Cheers
Simon