> > >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
Hi
OK my thoughts, no disrespect intended.
Is the table Users and not users? Are all the column names correct and are
they really in this tables??
also try
$result = mysql_query($query, $link) or die ($mysql_error())
to see what output mysql is giving as to why the query failed.
As I say no disrespect but you need to go back and try to unsderstand why it
is failing
M@
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
