Re: Mysqli issue

Jason Pruim wrote:

No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code:

    $stmt = mysqli_stmt_init($link);
    mysqli_stmt_prepare($stmt, "UPDATE purl.schreur (FName, LName, email, phone, record, subscribed, date, IPAddress, Business, Address1, City, State, Zip, Coffee, Meeting, areaPlans) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

That's an insert query. An update query is: update table set field1=value1, field2=value2 etc where id='X'; -- Postgresql & php tutorials http://www.designmagick.com/