Re: Mysqli issue

On 11 Sep 2008, at 17:08, Jason Pruim wrote:

On Sep 11, 2008, at 11:23 AM, Stut wrote:

On 11 Sep 2008, at 16:15, Jason Pruim wrote:

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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); mysqli_stmt_bind_param($stmt, 'ssssssssssssssssss', $_POST['txtFName'], $_POST['txtLName'], $_POST['txtEmail'], $_POST['txtPhone'], $_POST['txturl'], $_POST['record'], $_POST['subscribed'],$date, $_SERVER['REMOTE_ADDR'], $_POST['txtBusiness'], $_POST['txtAddress1'], $_POST['txtCity'], $_POST['txtState'], $_POST['txtZip'], $_POST['rdoCoffee'], $_POST['rdoTime'], $_POST['areaPlans']) ;//or die(mysqli_error($link)); echo "<BR>Dump of stmt:<BR>"; mysqli_stmt_execute($stmt) or die(mysqli_error($link)); Here is my error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(FName, LName, email, phone, record, subscribed, date, IPAddress, Business, Addr' at line 1 Now I may just be being dense but I can't figure out the problem... Migraines are not helping right now though.... Can anyone see my stupid mistake? :)

That's the syntax for an insert statement. Suggest you read this: http://dev.mysql.com/doc/refman/5.0/en/update.html

Hmmm... I looked at it, but didn't see anything that would help with a prepared statement :) Am I that dense or can't we do updates with prepared statements?

Your problem has nothing to do with your use of prepared statements. Your problem is to do with the syntax of the update statement you're trying to use. Insert statements can look like... insert into table (field1, field2) values (value1, value2); but update statements can only be in the form... update table set field1=value1, field2=value2 where field3=value3; Clear now? -Stut -- http://stut.net/