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: 279
        
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