eztv search crap

<?php

        // uTorrent search code
        // search the forum database for shows

        include_once 'includes/MySQL.inc.php';

        $db = new MySQL();
        $db->Connect( 'username', 'password', 'host', 'database' );

        $search = mysql_real_escape_string( htmlspecialchars( str_replace( ' ', '%', $_GET['search'] ) ) );

        if( empty( $search ) )
        {
                $db->Disconnect();
                echo 'Must supply search query.';
                die();
        }

        $sql = 'SELECT
                        *
                FROM
                        torrents
                WHERE
                        filename LIKE \'%'.$search.'%\'
                ORDER BY
                        data DESC';

        $res = $db->Query( $sql );

        $shows = $db->GetAll( $res );

        echo 'Results matching: "<b>'.$search.'</b>" <i>('.$db->GetCount($res).' result found)</i><br /><br />';

        if( $db->GetCount($res) > 0 )
        {
                foreach( $shows as $show )
                {
                        $mirrors = explode( ';', $show['mirror_list'] );
                        echo $show['data'] . ' - ' . preg_replace( '/('.$search.')/i', '<b>${1}</b>', $show['filename'] );
                        $i = 0;
                        foreach( $mirrors as $mirror )
                        {
                                if( $mirror )
                                {
                                        $i++;
                                        echo ' [<a href="'.$mirror.'" target="_blank">'.$i.'</a>]';
                                }
                        }
                        echo '<br />';
                }
        }

        $db->Disconnect();
}