2. PHPRunner General questions
  3. Calculation
This topic is locked

Calculation

 		7/18/2009 10:00:34
PHPRunner General questions
N
 Naelson author

Hello

Does someone could help me with this code:
[codebox]function BeforeEdit(&$values, $where, &$oldvalues, &$keys,&$message,$inline)

{

global $conn;
$sql="SELECT AR_Rec_Origem, Prazo, DATE_ADD(AR_Rec_Origem, INTERVAL Prazo DAY) AS Revelia FROM notificacao";

echo 'Revelia';
} // function BeforeEdit

[/codebox]
AR_Rec_Origem = Date

Prazo = Number

Revelia = Date
I add AR_Rec_Origem + Prazo = Revelia

18/07/2009 + 30 = 17/08/2009
I am not getting more, as appears 00/00/000
already thanks
Naelson
J
 		Jane 7/20/2009

Hi,
please see my changes below:

global $conn;

$sql="SELECT AR_Rec_Origem, Prazo, DATE_ADD(AR_Rec_Origem, INTERVAL Prazo DAY) AS Revelia FROM notificacao";

$rs = db_query($sql,$conn);

$data = db_fetch_array($rs);

echo "Revelia".$data["Revelia"];
N
 		Naelson author 7/20/2009

Hello,

Thanks for the response, is working perfectly with your information.

A hug
Naelson

Hi,

please see my changes below: