Re: Prepared Statements Insert Problem - Any more ideas?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD
<erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote:
> On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
> <erosenberg@xxxxxxxxxxxxxxxxxxxx> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux