"#ffaa55", 1 => "#ffb633" );
$i = 0;
$linenr = 1;
$db = mysql_connect("localhost", "guest");
mysql_select_db("unixscene",$db);
$searchstring = nix_sqlsearch($search, $in);
$prods = mysql_query("SELECT count(*) FROM productions p LEFT JOIN groups g ON p.groupname=g.id ".$searchstring ,$db);
$prodcount = mysql_result($prods,0);
$prods = mysql_query("SELECT p.id,p.file,p.name,g.homepage,g.name as groupname,p.type,p.year,p.release,p.os,p.source,p.comments,p.modified,p.added,p.screenshot FROM productions p LEFT JOIN groups g ON p.groupname=g.id ".$searchstring." ORDER BY ".$order ,$db);
while ($row = mysql_fetch_array($prods))
{
if ( $skip < $linenr && $i < 20 )
{
?>
