<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi, </tt><tt>Vishal!</tt><tt><br>
</tt><tt><br>
</tt><tt>You can find the answer to your question in the function's
documentation</tt><tt>[1]: </tt><tt><tt><span style="color:
rgb(0, 0, 0); font-size: 12px; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; text-align: justify;
text-indent: 0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255); text-decoration-style:
initial; text-decoration-color: initial; display: inline !
important; float: none;"><span></span>If the result gives many
rows, then multiple AVPs with corresponding name will be
added.<br>
<br>
Consider the following query:<br>
avp_db_query("select group where username='$tu'",
"$avp(group)");<br>
<br>
The first line of the result can be accessed using $avp(group)
(or $(avp(group)[0])), the second line $(avp(group)[1]), and
so on.<br>
<br>
</span></tt>[1]
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/2.4.x/avpops.html#idp3469424">http://www.opensips.org/html/docs/modules/2.4.x/avpops.html#idp3469424</a><br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Developer
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 11/24/2017 08:56 PM, Vishal Pai
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CACOmXtBKqBO7Wi=tZeBYN2jehvNZjtHS8pm=jiKcMNP=1sXtzg@mail.gmail.com">
<div dir="auto">Hi Everyone </div>
<div dir="auto"><br>
</div>
<div dir="auto">I just want to know what is correct to fetch all
the row from database using avp_db_query. Currently I am getting
only first row in result.</div>
<div dir="auto"><br>
</div>
<div dir="auto">One more think I want to know is it possible to
get array of for variable in Opensips configuration file.</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto">Thanks</div>
<div dir="auto"><br>
</div>
<div dir="auto">Vishal Pai </div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>