Select Code to Download

sub get_tmpl_loop_arrayref_bind
#Given an SQL query this will return an arrayref compatible with TMPL_
+LOOP. Works where the query does not contain a , before the 'from' an
+d where there is no subquery.
...
else
    {return \@loop_data;}
}

"SELECT username, name, role, email, phone, mobile, creation_date from
+ user where creator='".$session->param('username')."'";

<TMPL_LOOP NAME=all_users>
<!-- Data display -->
...
<TD WIDTH="25%" class="tblvlu"><TMPL_VAR NAME=phone></TD>
<TD WIDTH="25%" class="tblvlu"><TMPL_VAR NAME=mobile></TD>
<TD WIDTH="25%" class="tblvlu"><TMPL_VAR NAME=creation_date></TD>