Posted by william.clarke on 08/31/06 22:52

nephish wrote:
> wow, echo the query string. in a year of learning / using php and mysql
> i swear i have never thought of that. Good result too. It wasn't
> exactly what i thought. There was an extra space in the customer name.
> thanks.

Yep, echoing what you are really sending to the database can save you
hours of pain...
You might also want to look at doing your SQL transactions this way (
http://au3.php.net/manual/en/function.mysqli-prepare.php ) it tends to
lead to more maintainable code and other advantages (for example is you
use prepared statements with Oracle (PHP 5.1-PDO version-
http://au3.php.net/manual/en/function.pdo-prepare.php ) they will be
optimised more readily by Oracle than straight text queries (I'm not
sure if this advantage is true for MySQL but it may be.)) I tend to do
this the OO way but there is no problem doing it procedurally way
either.

Hope this is some use to you...

[Back to original message]