peshao
Posts: 17
|
Posted: 12/18/2012, 5:13 PM |
|
i need to call a stored procedure in a before show event. I tried to do this in a before show event:
$db = new clsDBlocal();
$SQL = "call update";
$db->query($SQL);
$db->close();
but nothing happens
any clue?
The stored procedure just do a cumulative sum for some records.
|
|
|
peshao
Posts: 17
|
Posted: 12/20/2012, 1:22 PM |
|
I think is working but i realize that i am using a user Variable @x into the SP. The problem is when i update a table the variable take a number (ID) that is used by the SP after (first an update, and then the SP), work perfect in phpadmin or other mysql admin program, but seem like the variable @x dont take the ID when i do an update via web (codecharge generate page)...Why? any help?
|
|
|
peshao
Posts: 17
|
Posted: 12/20/2012, 3:00 PM |
|
i was look for a solution and i found a very similar case in this post http://forums.codecharge.com/posts.php?post_id=82711
i am not sure how to do it in PHP and my triggers do not work when i update the table. any help pls?
|
|
|
|