2. PHPRunner General questions
  3. Update Record
This topic is locked

Update Record

 		2/14/2010 7:16:15 PM
PHPRunner General questions
L
 lpottle author

Hi,
I am new to php and mysql. I'm currently using the trial version of phprunner and so far I am very impressed with its self intuitiveness. But I need to update a record dynamically before the list is displayed. I have found that update is not supported in the Edit SQL Query section. Is it possible to accomplish an update record on a table through one of the table events in phprunner?
Thank you
J
 		Jane 2/15/2010

Hi,
use Before process event on the Eventstab to run update query.

Here is just a sample:

$strUpdate = "update tablename set ...";

CustomQuery($strUpdate);
L
 		lpottle author 2/16/2010



Hi,
use Before process event on the Eventstab to run update query.

Here is just a sample:

$strUpdate = "update tablename set ...";

CustomQuery($strUpdate);



Thank you very much! This information was very helpfull.