I am writing a PHP script to update a single record in a PF on our IBM i (AS/400). I will be updating several (but not all) columns in the record. What is the safest and most efficient approach? Should I concatenate a string together with the variable names to create an SQL update query and use db2_prepare? Should I use an array to provide the data for the SQL update query? Can I use db2_bind_param with an update query? Can someone suggest an approach and help me with the syntax? Thanks, Pat