PHP Code- How to check duplicate entries in Mysql Database

Posted by yash bhavnani on Stack Overflow See other posts from Stack Overflow or by yash bhavnani
Published on 2010-12-26T14:42:52Z Indexed on 2010/12/26 17:53 UTC
Read the original article Hit count: 221

Filed under:
|

Hi guys,

I am working on Google checkout API notification URL. I want to apply a check in my php code which will see if transaction ID present in transaction table of my DB, it will exit not process.

I am struggling into applying here. Can somebody help?

I want to check if trasaction ID exists in table of DB it will exit, it will not process:

*case "new-order-notification": 
            $sql = "update
                        transactions
                    set
                        remote_trans_id=\"".$_REQUEST["google-order-number"]."\", updated=now() 
                    where
                        id=".$_REQUEST["shopping-cart_items_item-1_merchant-item-id"]."
                    ";
            execute($sql, $conn);
            break;*

Regards

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql