On 22 Mar 2002 at 16:41, Ashley M. Kirchner wrote:

> Rick Emery wrote:
>     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";

seems there is something wrong with the query, can you either echo the query and 
feed it directly to mysql, (e.g. in phpmyadmin) see what happens?

also, i always do queries like this:

$result=mysql_query($query) or die ('<H1><font color=red>Bad database request 
setting email flag </font></H2> in :'
        .__FILE__ .' line '.__LINE__
        .'<br /><b>The query used was:</b> '.$query
        .'<br /><b>MySQL says</b> '.mysql_error() );

I find it is extremely useful in debugging.

 !              please check my email address                   !  
 !      only my email [EMAIL PROTECTED] works           !
 !      email [EMAIL PROTECTED] is a black hole since januari 2002 !

Chris Hayes - Droef 35 - Wageningen

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to