hello,<br>
I tried following<br>
if (is_method("INVITET"))<br>
{<br>
avp_db_query("select count from load_count where dest='1'","$avp(i:1)");<br>
avp_db_query("select count from load_count where dest='2'","$avp(i:2)");<br>
if ($(avp(i:1){<a href="http://s.int">s.int</a>})<$(avp(i:2){<a href="http://s.int">s.int</a>})<br>
{<br>
#$avp(i:3)=1+(avp(i:1){<a href="http://s.int">s.int</a>};<br>
#avp_db_query("update load_count set count='$(avp(i:3)' where dest='1';");<br>
avp_op("$avp(i:1)", "add/1/g");<br>
forward("<a href="http://172.29.9.140:5060">172.29.9.140:5060</a>");<br>
exit;<br>
}<br>
else<br>
{ #$avp(i:3)=1+(avp(i:2){<a href="http://s.int">s.int</a>};<br>
#avp_db_query("update load_count set count='$(avp(i:3)' where dest='2';");<br>
avp_op("$avp(i:2)", "add/1/g");<br>
forward("<a href="http://172.29.9.131:5060">172.29.9.131:5060</a>");<br>
exit;<br>
}<br>
<br>
}<br>
<br>
I think there is problem in update query<br>
How to add count?<br>
please help<br>
thank you<br><br><br>