2. PHPRunner General questions
  3. After record Added Event
This topic is locked

After record Added Event

 		10/16/2010 12:33:14 AM
PHPRunner General questions
U
 umanga author

Hi .... i have table model with
Model_No

Model_name

Model_size

Model_Description
I want to Update

Model_No

Model_name

Model_size Field values in to a Model_Description field
How do i coding after record added event
plz help me ................................
T
 		tedwilder 10/16/2010

i would try something like

$sql="update * from tablename set columname where Model_No=".$_Session["modelno"];

$rs=CustomQuery($sql);

$dataresult=db_fetch_array($rs);
you need to try your sql syntax out of phprunner : ( navicat lite ( free) or phpmyadmin) are great to debug sql statement.( my example wont actually work it's just an idea where to place your sql update request).

also chek mysql UPDATE syntax : http://dev.mysql.com/doc/refman/5.0/en/update.html
U
 		umanga author 10/17/2010



i would try something like

$sql="update * from tablename set columname where Model_No=".$_Session["modelno"];

$rs=CustomQuery($sql);

$dataresult=db_fetch_array($rs);
you need to try your sql syntax out of phprunner : ( navicat lite ( free) or phpmyadmin) are great to debug sql statement.( my example wont actually work it's just an idea where to place your sql update request).

also chek mysql UPDATE syntax : http://dev.mysql.com/doc/refman/5.0/en/update.html



thankz for the reply but i need other thing..................
In My model table Add page dont have the description field
Only im doing filling model no,size ..... after filling those two values of model no and the size it those two values should be updated in the description field.

how do i do this thing