duplicate entry error. How to catch?

bad table design, u need primary key (with auto_increment) to get it work well in future.

---

This is a temporary table. It gets used once to run koolreport on, for rendering. But please tell me how I insert a select into a autoincrement field for the future?

proof that an old dog can learn new tricks