Posted by Rik on 01/24/07 18:35

On Wed, 24 Jan 2007 19:26:57 +0100, Schmidty <schmidty@baronholding.com>=
=

wrote:
> connection. I am getting the error (per my validation) "ERROR: Could
> not execute query." from the third line in the function;
>
> Code Example =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
>
> public function updatedb($userID){
> if (!$this->mysqli){ echo "ERROR: Database connection lost.";
> $query2 =3D "UPDATE personalinfo SET checked =3D 'TRUE' WHERE userID=
=3D
> '$userID'";
> $this->mysqli->query($query2) or die("ERROR: Could not execute
> query.");
> } // end function
>
> End Example =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D


$this->mysqli->query($query2) or die("ERROR: Could not execute query.
MySQL said: ".$this->mysqli->error);

-- =

Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse =

possible errors and weird content. *

• Next in forum: Re: HTML table Update row PHP/MySQL
• Prev in forum: Re: mysqli connections and oop
• Thread view: Re: mysqli connections and oop

[Reply to this message]