[Mone']

hack work perfectly !


patvdv your code is giving me error can you check your code as i'd like to have your layout

Mone'

Originally posted by patvdv


Change the PHP code in search.php like this:

PHP Code:

// begin last search hack by JP
 $colstart1="<td bgcolor='{ secondaltcolor }'><smallfont>";
 $colstart2="<td align='center' bgcolor=' { firstaltcolor }' width=15%><smallfont>";
 $colend="</smallfont></td>";
 $lastsearches=$DB_site->query('SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE queryst
ring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10');
 while ($lastsearchcount=$DB_site->fetch_array($lastsearches)):
 $lastsearchdate=vbdate($dateformat,$lastsearchcount[dateline]);
 $lastsearchtime=vbdate($timeformat,$lastsearchcount[dateline]);
 $ourlastquery=$lastsearchcount[querystring];
 $ourlastquery=bbcodeparse($ourlastquery);
 $ourlastquery=censortext($ourlastquery);
 $lastsearchresultscount="$lastsearchcount[postids]";
 $lastsearchresultscount=explode(",",$lastsearchresultscount);
 $lastsearchresultscount=sizeof($lastsearchresultscount);
 $lastsearchmatches.="$lastsearchresultscount posts<br>";
 $lastsearchkeywords.="<a href='search.php?s=&action=showresults&searchid=$lastsearchcount[searchid]&sortby=lastpost&sortorder=desce
nding'>$ourlastquery</a><br>";
 $lastsearchtimestamp.="$lastsearchdate at $lastsearchtime<br>";
 endwhile;
 $lastsearch="<tr>".$colstart2.$lastsearchmatches.$colend.$colstart1.$lastsearchkeywords.$colend.$colstart2.$lastsearchtimestamp.$co
lend."</tr>";
// end last search hack by JP 


It will also use alternating colours for the columns