<?php // BODY:  display Most Popular Search table ?>

<!--    Most popular search table    -->
        <br />
        <div style="text-align:center;">
        <div id="most_pop" class="tblhead cntr">
            <p class="tblhead"><?php echo"".$sph_messages['mostpop'].""; ?></p>
            <table width="100%" align="center" cellpadding="3" cellspacing = "1">
                <tr class="tblhead">
                    <td><?php echo $sph_messages['query'] ?></td>
                    <td><?php echo $sph_messages['count'] ?></td>
                    <td><?php echo $sph_messages['results'] ?></td>
                    <td><?php echo $sph_messages['lastquery']?></td>
                </tr>
<?php
    while (($row=mysql_fetch_row($result)) && $count < $pop_rows) {
        $word = str_replace("\"", "", $row[0]);
        if ($no_zeros == '0' || ($no_zeros == '1' && intval($row[3]))) {
            $count++;
?>
                <tr class="<?php echo $bgcolor ?> cntr">
                    <td><a href="<?php echo $search_string ;?>?query=<?php echo$word?>&amp;search=1&amp;media_only=<?php echo$row[4]?>&amp;type=<?php echo$type?>&amp;category=<?php echo$category?>&amp;catid=<?php echo$catid?>&amp;mark=<?php echo$mark?>&amp;results=<?php echo$results?>&amp;db=<?php echo$db?>&amp;prefix=<?php echo$prefix?>"><?php echo$word?></a></td>
                    <td><?php echo $row[1] ?></td>
                    <td><?php echo intval($row[3]) ?></td>
                    <td><?php echo $row[2] ?></td>
                </tr>
<?php
            if ($bgcolor=='odrow') {
                $bgcolor='evrow';
            } else {
                $bgcolor='odrow';
            }
        }
    }
?>
            </table>
        </div>
        </div>
<?php // ?>