hi,

i am using mysql db.

i have table called setting
in that table i have setting_name, setting_title, setting_description, setting_value.

i like to update title description and value but not the name as i will always be same..

i need to put information in array then pass on to database.

i cant think of how i can do this

public function update( $setting ){
global $database, $db;



$name = $setting['name'];
$title = $setting['title'];
$desc = $setting['desc'];
$value = $setting['value'];

$sql = " UPDATE ".self::$table_name;
$sql.= " SET title='{$title}', description='$desc', value='{$value}'";
$sql.= " WHERE _name = '{$name}'";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

how can i write a loop which insert data into database.


please help me. i have check few site but i cant find anything which i need.

thanks in advance