UPDATE words SET word = '#form.word#', type = '#form.type#' WHERE word_id = #form.word_id# SELECT word_id FROM part_of_speech_word_map WHERE word_id = #form.word_id# SELECT part_of_speech_id, part_of_speech FROM parts_of_speech WHERE part_of_speech = '#form.part_of_speech1#' or part_of_speech = '#form.part_of_speech2#' or part_of_speech = '#form.part_of_speech3#' INSERT INTO part_of_speech_word_map (part_of_speech_id, word_id) VALUES (#part_of_speech_id#, #form.word_id#) UPDATE part_of_speech_word_map SET part_of_speech_id = #part_of_speech_id# WHERE word_id = #form.word_id# SELECT word_id FROM category_word_map WHERE word_id = #form.word_id# SELECT word_id FROM emotion_word_map WHERE word_id = #form.word_id# SELECT word_id FROM words WHERE word = '#form.word#' SELECT category_id, category FROM categories WHERE category = '#form.category1#' or category = '#form.category2#' or category = '#form.category3#' SELECT emotion_id, emotion FROM emotions WHERE emotion = '#form.emotion1#' or emotion = '#form.emotion2#' or emotion = '#form.emotion3#' DELETE category_id, word_id FROM category_word_map WHERE word_id = #form.word_id# INSERT INTO category_word_map (category_id, word_id) VALUES (#category_id#, #form.word_id#) DELETE emotion_id, word_id FROM emotion_word_map WHERE word_id = #form.word_id# INSERT INTO emotion_word_map (emotion_id, word_id) VALUES (#emotion_id#, #form.word_id#) You have successfully updated the information for record no. #form.word_id#.