| Mod Name | Populatity | Tags | License |
|---|
\n";
$query= mysql_real_escape_string ($query);
$res = mysql_query("SELECT * FROM mods WHERE tags LIKE '%$query%' ORDER BY likes DESC",$handle) or SQLerror("MySQL Query Error","Error on searching database.mods.tags for '$query'");
$alternate=1;
// Get projects loop
while ($hash = mysql_fetch_assoc($res)){
if ($alternate==0){
$bgcolor="#FFFFFF";
}else{
$bgcolor="#FFFFBD";
}
// Owner name from id (by Phitherek_)
$q = mysql_query("SELECT name FROM users WHERE id=".$hash['owner']);
$qr = mysql_fetch_array($q);
// End of Phitherek_' s code
// Owner name instead of id (by Phitherek_)
echo "![](\"images/topicicon_read.jpg\") | {$hash['name']}
by {$qr['name']} | ";
// End of Phitherek_' s change
echo "{$hash['likes']} | ";
echo "{$hash['tags']} | ";
echo "{$hash['license']} |
\n";
$alternate=1-$alternate;
}
echo "";
?>