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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
