Re: MySQL problem - stumped

On Saturday 10 March 2001 19:58, you wrote: > The following code is giving an me problems, I can't figure it out to > save my soul. The last line gives: > > Here is the code: > > $link = db_connect(); > $query = "UPDATE Users SET firstname='$firstname', > lastname='$lastname' > WHERE username='$user' && password='$password'"; > $result = mysql_query($query, $link); > $err = mysql_error(); > echo "Errors:".$err; > $rows = mysql_affected_rows($result); > > And here is the output: > Errors: > Warning: Supplied argument is not a valid MySQL-Link resource in > /****/*****/****/**********.********.***/db.php on line 147 > > Line 147, is the last line in the above snippet. I cleared out the > path name for security, no offense intended :) This one? > $rows = mysql_affected_rows($result); Try $rows = mysql_affected_rows($link); -- Christian Reiniger LGDC Webmaster (http://sunsite.dk/lgdc/) The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offence. - Edsger W. Dijkstra