TalkPHP - View Single Post

Wildhoney · 09-20-2007, 12:31 PM

...Or of course if you wanted to be advanced about this then you could put the SELECT and the UPDATE into one MySQL statement.

Code:

INSERT INTO
	myTable
	(myKey, myColumn1)
VALUES
	('myKey', 'myColumn1')
ON DUPLICATE KEY
UPDATE
	myColumn1 = 'myData1'

That's for future reference. * Stops confusing matters *

09-20-2007, 12:31 PM	#9 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	...Or of course if you wanted to be advanced about this then you could put the `SELECT` and the `UPDATE` into one MySQL statement. Code: INSERT INTO myTable (myKey, myColumn1) VALUES ('myKey', 'myColumn1') ON DUPLICATE KEY UPDATE myColumn1 = 'myData1' That's for future reference. * Stops confusing matters * __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.