mysql, php, mp3 - a variable problem

[Ole Hornauer <ohorn77@gmx.de>]

hi,
i put a script together to scan a directory and its subdirectories for 
all mp3 files. the tag informations and path then should be put into a 
mysql database.
i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/ 
which returns the needed tag info from one file.
the script to recursively scan a dir i got from groups.google.

using the mphp3.php with one file is simple (demo from website):
<?
include("mphp3.php");
$info = New mphp3(2); 
$info->load("test.mp3"); 
echo $info->title." is a nice song. it's encoded with".$info->
bitrate."kbps.";
?>

my code to include the db:
<?
  include("mphp3.php");

  mysql_connect("192.168.100.12","user","password") or die ("no connect 
to db");
  mysql_select_db("music") or die ("db does not exist");

  function scan_dir($dir)
{
    $info = New mphp3(2);

    $handle = @opendir($dir);
    while ($file = @readdir ($handle))
    {
        if (eregi("^\.{1,2}$",$file))
        {
            continue;
        }

        if(is_dir($dir.$file))
        {
            scan_dir($dir.$file."/");
        }
        else
        {
            $info->load("/".$dir.$file);

            $query ="insert into mp3 (
                              file,
                              path,
                              artist,
                              title,
                              album)
            values (
                     '$info2->filename',
                     '$dir',
                     '$info2->v2_artist',
                     '$info2->v2_title',
                     '$info2->v2_album');";

            mysql_query($query);
        }
    }
    @closedir($handle);
}
scan_dir("mp3/");
?>

but all it does is to put the path ($dir) into the database. everything 
else is ignored. an error does not occur. since the simple demo works 
fine i think its a problem with the validity of variables.
i'm new to php, so could anybody give me a hint on what mightbe wrong 
with my code please?

thanx a lot

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php