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>

    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

Reply via email to