lines as long as 380 characters are hard to read. hit enter every now and then, please.
# [EMAIL PROTECTED] / 2003-06-15 17:47:39 -0700: > I created the following function to move a record from one table to > another. The only difference in the table structures are the > auto-incremented id column. then you should probably have just one table with a flag column. > The purpose of my function is to allow Admin to get user input from > the "queue" table and after "approving it" she puts it in a table that > will display as current events. The "insert" works great, but the > delete from the "queue" table isn't working and the only work around > is to go back to the queue table and delete the record that was just > inserted into the "current events" table. what does "isn't working" mean? http://www.catb.org/~esr/faqs/smart-questions.html -- If you cc me or remove the list(s) completely I'll most likely ignore your message. see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]