Behavior of ON DUPLICATE KEY

2005-05-15 Thread Taisuke Yamada
Hi. I found behavior of "ON DUPLICATE KEY" bit odd, and would like to know if it's a bug or feature. I'm trying to "insert" or "add" (not "replace") data of one table to another table and came up with following statement: CREATE TABLE foo (id INT NOT NULL PRIMARY KEY, value

Re: What's wrong with this code?

2005-05-15 Thread Taisuke Yamada
=%s WHERE ResumeID=%s, $dateEdited, $status, $resumeID); mysql_query($updateSQL, $TBAJobLink) or die(mysql_error()); [snip] What's up? What's wrong with my code? The first line in the page is a link to the connections file. -- Taisuke Yamada [EMAIL PROTECTED] 2268 E9A2 D4F9 014E F11D

Re: Behavior of ON DUPLICATE KEY

2005-05-15 Thread Taisuke Yamada
believe yours is one of those. -- Taisuke Yamada [EMAIL PROTECTED], http://rakugaki.org/ 2268 E9A2 D4F9 014E F11D 1DF7 DCA3 83BC 78E5 CD3A Message to my public address may not be handled in a timely manner. For a direct contact, please use my private address on my namecard. signature.asc Description