the $db variable isn't referencing a proper connection. As you did not create 
the db connection in this function, I'm assuming it's a scope problem. Make 
sure that $db is global, and then add a global statement to the first line in 
the function for this variable. 

the $db you're referencing in the query is not the same $db that you assigned 
the connection parameter to. If you're a sloppy programmer like me, and you 
only have 1 connection, you can eliminate it from the query statement if you 
want. 

-Micah 

On Wednesday 03 March 2004 12:33 pm, Craig Hoffman wrote:
> ok, I uncommented the line and changed a few things around.  However I
> am still getting errors.   I really do appreciate everyone's  help.
> Thanks CH
> Here is the 'new' code:
>
> function notify_password($username, $password)
> // notify the user that their password has been changed
> {
>
>     $query ="SELECT username FROM users WHERE username=('$username')";
> => line 65    $result = mysql_query($query, $db);
>      if (!$query)
>      {
>        return false;  // not changed
>      }
> => line 70    else if (mysql_num_rows($result)==1)
>
>        $user_id = mysql_result($result, 0, 'user_id');
>        $from = "From: [EMAIL PROTECTED] \r\n";
>        $mesg = "Your password has been changed to $password \r\n"
>                ."You might want to change it next time you log in. \r\n";
>
>        if (mail($username, 'Cyclists Edge login information', $mesg,
> $from))
>          return true;
>        else
>          return false;
>      }
>
>
> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> resource in
> /Users/choffman/Sites/www/cyclistsedge/include/
> forgot_password_functions.php on line 65
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL
> result resource in
> /Users/choffman/Sites/www/cyclistsedge/include/
> forgot_password_functions.php on line 70
>   Your new password has been sent to your email address.
>
> __________________________________
> Craig Hoffman - eClimb Media
>
> v: (847) 644 - 8914
> f: (847) 866 - 1946
> e: [EMAIL PROTECTED]
> w: www.eclimb.net
> _________________________________
>
> On Mar 3, 2004, at 2:17 PM, Daniel Clark wrote:
> >>      $query ="SELECT username FROM users WHERE
> >> username=('$username')";
> >>     // $result = mysql_query($query, $db);
> >
> > Above line should be uncommented.
> >
> >>      if (!$query)
> >
> > And the "if" checking the number of rows returned from the $result set.
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php

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

Reply via email to