Skip navigation
Currently Being Moderated

Query in Custom Trigger

Nov 4, 2011 3:15 AM

Hi you all,


I have been using custom triggers becuase they are very handy. I however need to do a query that does an select and  based on result do a loop and process some update or inserts. Well my problem is that i dont know of a native way to fetch result in a custom trigger. I have always been doing something like this for my updates for example:


$update_prices = "update cart_details set price = '$cost' where cart_details_id='$cart_details_id' ";

                        $result2 = $tNG->connection->execute($update_prices);


However when it come to getting the results of a select I am lost.I wish there was a manual or some kind of documentation for this framework. Any ideas ???


More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points