Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread tamouse mailing lists
On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD wrote: > mysqli_stmt_bind_result(): Number of bind variables doesn't match number of > fields in prepared statement What exactly is unclear about that? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread tamouse mailing lists
> if($stmt = mysqli_stmt_prepare($stmt, "INSERT INTO Intake3 (Site, MedRec, > Fname, Lname, Phone, Height, Sex, Hx, Bday, Age) > VALUES(?,?,?,?,?,?,?,?,?,?")!=0) Let me break this into smaller chunks: if ($a = $b != 0) Precedence rules show that comparisons (!= in this case) come before assign

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread Jim Giner
So do u have the revised code to show us? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD wrote: > On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD > wrote: >> >> Dear List - >> >> I wish to accomplish the following with prepared statements: >> >> $stmt = mysqli_stmt_init($cxn); >> if($stmt = mysqli_stmt_prepare($stmt, "

[PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread Jim Giner
On 9/2/2012 12:45 AM, Ethan Rosenberg, PhD wrote: Dear List - I wish to accomplish the following with prepared statements: FYI - The Database: mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++---

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Ethan Rosenberg, PhD
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD 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)

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Ethan Rosenberg, PhD
Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 [email protected] On 09/02/2012 08:33 AM, Matijn Woudt wrote: On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD wrote: Dear List - I wish to

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD 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,