Hello guys..
well, I want to update my table from a form.
<?
$dbname="database";
$dbuser="user";
$dbpasswd="pass";
$conn = db2_pconnect($dbname,$dbuser,$dbpasswd);
$sql = "UPDATE Customers SET cust_id='$customerID2', firstnme='$First2', lastname='$Last2' where cust_id='$customerID2'";
$result=db2_exec($conn,$sql);
if($result){
echo "Row Updated."."\n";
}
else {
echo "Row not updated."."\n";
echo db2_stmt_errormsg();

but nothing happen..

FYI, I can connect to database, insert, select and delete data.

Regard.

have you checked the error message to see if there is an error on the update
using MySQL its something like:
but you will need to see what error handling is available under DB2

thanks before.. Well, I deal with DB2. not mysql.. or maybe I don't get what do you mean.

yeah sorry about that
mis read your post expecting you to be using MySQL, edited it when I realised you were using DB2.

I'd suggest you check the PHP help system to find out how you examine how errors are reported when using DB2

hehe..
but when I run the page which action calls those scripts, I get blank page. I wish I get some notification about error.. But nothing,
if($result){
echo "Row Updated."."\n";
}
else {
echo "No Row updated."."\n";

I dont get "Row Update" neither "No Row updated"... very confuse..

I suspect you need to examine the PHP: db2_stmt_error - Manual function.

what level of error_reporting are you using?

I ve seen this sort of problem before on PHP5, its soemthugn to do with how the pHP installation is setup, it used tobe very developer friendly, these days its more aimed a t a production server.

the fault may well be a syntax error in the included file