2. PHPRunner General questions
  3. [SOLVED]  Updating another table with date field
This topic is locked
[SOLVED]

 Updating another table with date field

 		5/19/2012 10:30:08 PM
PHPRunner General questions
J
 joiresende author

I can update any field in another table that contains the least dates, would be like. I use the example below, I am wrong for dates?
CustomQuery ("Update TABLE1 SET purchaseDATE = ". $ Values ​​["purchasedate"]. " where = BarCode ". $ values ​​["BarCode"]);
D
 		danaci 5/20/2012



I can update any field in another table that contains the least dates, would be like. I use the example below, I am wrong for dates?
CustomQuery ("Update TABLE1 SET purchaseDATE = ". date("Y-m-d",$ Values ​​["purchasedate"]). " where = BarCode ". $ values ​​["BarCode"]);
J
 		joiresende author 5/20/2012

Thanks it worked fine.

But I had already solved by adding () in the field thereby.

(CustomQuery ("Update TABLE1 SET **[size="4"][/size]purchaseDATE`** = ". $ Values ​​["purchasedate"]. "Where = BarCode". $ Values ​​["BarCode"])<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=66229&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />