$sth = $dbh->prepare("select author, title, language, format, filename, fullpath, category, tags from ebooks where author like'%$searchauth%' and title like'%$searchtitle%' and language='$searchlang' and format='$searchfmt' and category like'%$searchcategory%' and tags like'%$searchtags%' LIMIT 50;");<br/>

##</code><code>##

$sth->execute();
$loopcount = 0;

while ($row = $sth->fetchrow_arrayref()) {
#	print "@$row[0] @$row[1] @$row[2] @$row[3] \n";
	print "File found: @$row[4] \n";
#	print "Category: @$row[6] Tags: @$row[7]\n\n";

$author	    = @$row[0];
$title      = @$row[1];
$results[$loopcount] [1] = (@$row[1]); THIS LINE IS NOT WORKING.
$language   = @$row[2];
$format     = @$row[3];
$filename   = @$row[4];
$fullpath   = @$row[5];
$category   = @$row[6];
$tags       = @$row[7];
print "$loopcount $results[$loopcount] [1]";
$loopcount++;
	}