asterisk2billing.org http://forum.asterisk2billing.org/ |
|
A2B_entity_Password http://forum.asterisk2billing.org/viewtopic.php?f=33&t=10931 |
Page 1 of 1 |
Author: | raykt [ Thu Sep 11, 2014 12:20 am ] |
Post subject: | A2B_entity_Password |
I am trying to update both cc_card and cc_sip_buddies with same password once the user changed . SQL Query(Work) update cc_card A1 inner join cc_sip_buddies A2 on A1.ID = A2.ID_CC_Card set A2.secret=1234,A1.uipass=1234 where A1.id=1; For PHP, $QUERY = "UPDATE cc_card A1 inner join cc_sip_buddis A2 on A1.ID=A2.ID_CC_Card SET A1.uipass= ".$NewPassword."',A2.secret='".$NewPassword."' WHERE ( A1.ID = ".$_SESSION["card_id"]." ) "; When I tried it, it shows update successfully but it is not updating in.. |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |