Need a generic update function to update a mysql table

[colap]

Can anyone post a generic update function to update mysql table.

The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;

[ManiacDan]

You're going to have to be more specific.  You can write a function that will accept an associative array and will construct an update statement.  However, you won't be able to write it to have intelligence about the data type for the queries without doing a SHOW CREATE TABLE and parsing it yourself.

 

-Dan