Re: Prepared Statements Insert Problem - Any more ideas?

On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD <erosenberg@hygeiabiomedical.com> wrote: > On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD > <erosenberg@hygeiabiomedical.com> wrote: >> >> Dear List - >> >> I wish to accomplish the following with prepared statements: >> >> $stmt = mysqli_stmt_init($cxn); >> if($stmt = mysqli_stmt_prepare($stmt, "INSERT INTO Intake3 (Site, >> MedRec, Fname, Lname, Phone, Height, Sex, Hx, Bday, Age) >> VALUES(?,?,?,?,?,?,?,?,?,?")!=0) > > > >> Help and advice, please. >> >> Ethan Rosenberg >> > *+++++++++++++++++ > > Any more idead? You're still missing the closing parenthesis here, and I told you that mysqli_error should give you some more info. Did you try that? Your reply with 'no error' doesn't really make sense on it's own.. Also, IIRC, I think you need to use one extra set of parenthesis, like this: if(($stmt = mysqli_stmt_prepare()) != 0) - Matijn