FUDforum: comp.lang.php » try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE

Home » Imported messages » comp.lang.php » try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE

Show: Today's Messages :: Polls :: Message Navigator

try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE [message #175294]

Thu, 01 September 2011 03:50

jwcarlton
Messages: 76
Registered: December 2010

Karma:

Member

I promise that this is a PHP question, and not MySQL!

I'm currently sending a query of INSERT INTO... ON DUPLICATE KEY
UPDATE. But, I'd like to know which one happened in my PHP; was it
new, or was it updated?

Is there a way to find this? Or should I do something like:

try {
$query = sprintf("INSERT...");
$sth = mysql_query($query) or die(mysql_error());

$duplicate = false;
}

catch (Exception $e) {
$query = sprintf("UPDATE...");
$sth = mysql_query($query) or die(mysql_error());

$duplicate = true;
}

Report message to a moderator

[Message index]

		try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE By: jwcarlton on Thu, 01 September 2011 03:50
		Re: try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE By: Chuck Anderson on Thu, 01 September 2011 04:37
		Re: try / catch or INSERT INTO... ON DUPLICATE KEY UPDATE By: jwcarlton on Thu, 01 September 2011 05:35

Previous Topic:	does paypal standard method supports for recurring payment.
Next Topic:	php help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:23:48 GMT 2024

Total time taken to generate the page: 0.04127 seconds