perlquestion jarvis Hi there, can anyone help??... Please!!<BR> I'm new to all this and i am trying to output data from a search query on mySQL to a loop variable using the loop function in HTML::Template <code>( <TMPL_LOOP NAME=""> <TMPL_VAR NAME=""> </TMPL_LOOP>)</code> I understand that i have to return an array of hashes to the HTML::Template module, but i cant seem to successfully convert the output from mySQL to this array of hashes. I realise that i am missing something obvious, but i can't get my head around it. My code is something like this... <code> ##necessary stuff, use CGI etc... use constant TMPL_FILE => "C:/Xitami/cgi-bin6/templates/mytemplate.tmpl"; my $tmpl = new HTML::Template( filename => TMPL_FILE, no_includes => 1 ); ##some other bits, then $dbh=DBI->connect($datasource,$user,$pass,{AutoCommit=> 1}) or die "Can't Connect"; $sth=$dbh->prepare("SELECT * FROM Videos WHERE $FieldN LIKE ?") or die; $sth->execute($SearchCrit); @vidinfo = $sth->fetchrow_array(); </code><strong> how do i turn this bit (above - @vidinfo)<br> into an array of hashes<br> so that this bit (below)will output<br> it properly???</strong> <code> $tmpl->param( stuff =>\@whatever ); $tmpl->output; </code> all help gratefully received..