3 function add_movement_type($name)
5 $sql = "INSERT INTO ".TB_PREF."movement_types (name)
8 db_query($sql, "could not add item movement type");
11 function update_movement_type($type_id, $name)
13 $sql = "UPDATE ".TB_PREF."movement_types SET name='$name'
16 db_query($sql, "could not update item movement type");
19 function get_all_movement_type()
21 $sql = "SELECT * FROM ".TB_PREF."movement_types";
23 return db_query($sql, "could not get all item movement type");
26 function get_movement_type($type_id)
28 $sql = "SELECT * FROM ".TB_PREF."movement_types WHERE id=$type_id";
30 $result = db_query($sql, "could not get item movement type");
32 return db_fetch($result);
35 function delete_movement_type($type_id)
37 $sql="DELETE FROM ".TB_PREF."movement_types WHERE id=$type_id";
39 db_query($sql, "could not delete item movement type");