Re: [PHP] Been staring at the code for too long...
On Jan 10, 2009, at 8:35 AM, tedd wrote: At 1:38 PM -0500 1/9/09, Jason Pruim wrote: mysqli_stmt_prepare($stmt, "UPDATE database.table ( Jason: Here's the problem, your code should read: mysqli_stmt_prepare($stmt, "UPDATE database.table SET ( You forgot the "SET". As a point of practice, I always use: $query = "UPDATE $db_table SET first = '$first', second = '$second' WHERE id = '$id' "; and then use the $query, such as: mysqli_stmt_prepare($stmt, $query); Hey tedd, I hadn't done a update in a prepared statement before... and it was something I set up quite awhile ago... I ended up rewriting it just to refresh my mind on how it was working :) I know every one has their own way, but also consider the following code: --- code --- $result = mysql_query($query) or die(report($query,__LINE__ ,__FILE__)); // with an accompanying function of: // show dB errors == function report($query, $line, $file) { echo($query . '' .$line . '' . $file . '' . mysql_error()); } --- end of code --- This will: 1. Allow you to see your errors in more detail during development; 2. After the development, you have only to comment out one line of code (the echo) to stop reporting dB errors project-wide. I really need to start doing that... Then I can track down the issues easier hopefully... :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Been staring at the code for too long...
At 1:38 PM -0500 1/9/09, Jason Pruim wrote: mysqli_stmt_prepare($stmt, "UPDATE database.table ( Jason: Here's the problem, your code should read: mysqli_stmt_prepare($stmt, "UPDATE database.table SET ( You forgot the "SET". As a point of practice, I always use: $query = "UPDATE $db_table SET first = '$first', second = '$second' WHERE id = '$id' "; and then use the $query, such as: mysqli_stmt_prepare($stmt, $query); I know every one has their own way, but also consider the following code: --- code --- $result = mysql_query($query) or die(report($query,__LINE__ ,__FILE__)); // with an accompanying function of: // show dB errors == function report($query, $line, $file) { echo($query . '' .$line . '' . $file . '' . mysql_error()); } --- end of code --- This will: 1. Allow you to see your errors in more detail during development; 2. After the development, you have only to comment out one line of code (the echo) to stop reporting dB errors project-wide. It works for me. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Been staring at the code for too long...
On Jan 9, 2009, at 4:29 PM, Daniel Brown wrote: On Fri, Jan 9, 2009 at 13:38, Jason Pruim wrote: Okay... So I know this is a stupid question... It sure is. I'm going to rewrite the whole thing anyway... I think I can do it better/more efficient given the time to look at it. I really need to do more programming more often...I get rusty to quickly :P -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Been staring at the code for too long...
On Fri, Jan 9, 2009 at 13:38, Jason Pruim wrote: > Okay... So I know this is a stupid question... It sure is. -- daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Been staring at the code for too long...
> >mysqli_stmt_prepare($stmt, "UPDATE database.table ( >FName, LName, email, phone, > url, record, >subscribed, date, > IPAddress, Business, >Address1, City, State, > Zip, >Coffee, Meeting, > areaPlans) >VALUES > (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); > > > Warning: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param]: > invalid object or resource mysqli_stmt in /public_html/purl/purlprocess.php > on line 67 > 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, url, recor' at line 1 > > Am I just going crazy or is there something really wrong? > > Okay.. I'm done... First stupid question of the year... Only 3,349,587 more > to go for the year! :P I don't work with MySQL, but shouldn't the UPDATE syntax be something like this: mysqli_stmt_prepare($stmt, "UPDATE database.table SET FName = ?, LName = ?, email = ?, phone = ? WHERE id = ?");