MySQL Insert Into Issues
<p>Im new to PHP/MYSQL so im sry if you feel this is a bad question but i cant get this to work. Its for a login form. The issue i have is with the insert into with the insert query part. I apreciate if anyone could help me get this fixed
:) TY in advance.</p>

<pre><code>    function InsertIntoDB(&amp;$formvars)
{

    $confirmcode = $this-&gt;MakeConfirmationMd5($formvars['email']);

    $formvars['confirmcode'] = $confirmcode;

    $insert_query = 'insert into '.$this-&gt;tablename.'(
            name,
            email,
            username,
            password,
            confirmcode
            )
            values
            (
            "' . $this-&gt;SanitizeForSQL($formvars['name']) . '",
            "' . $this-&gt;SanitizeForSQL($formvars['email']) . '",
            "' . $this-&gt;SanitizeForSQL($formvars['username']) . '",
            "' . md5($formvars['password']) . '",
            "' . $confirmcode . '"
            )';      
    if(!mysqli_query( $this-&gt;connection, $insert_query ))
    {
        $this-&gt;HandleDBError("Error inserting data to the table\nquery:$insert_query");
        return false;
    }        
    return true;
}
</code></pre>