Rick Emery wrote:
> $result = mysql_query(.....)'
> mysql_num_rows($result)
Hrm, this is resulting in:
<b>Warning</b>: Supplied argument is not a valid MySQL result resource in
<b>./index.php</b> on line <b>16</b><br>
Rows
The query does get executed, and the record does get changed.
The code looks like this:
$conn = @MYSQL_CONNECT($host,$user,$password) ;
mysql_select_db($database, $conn);
$query = "UPDATE clients SET email_flag='0' WHERE
MD5(concat(email_address,'$key'))='$uniqueID' ";
$result = mysql_query($query, $conn);
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
--
W | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
