Multiple rows in mysql

<?php //...  
 
//include the class and connects to the DB  
 
$max_upload = 5;
 
$album = new album($username , $max_upload);  
 
//check if he user clicked for removing and call the delete function  
 
if($_GET["del_pict_id"])  
 
    $album->delete_picture();  
 
//check if user is uploading right now and   call the function that treat uploaded files  
 
if($_GET["up"])  
 
    $album->store_picture();  
 
//query and display the user files call ths function.  
 
$album->display_album();  
 
//this function will display the form for uploading the files  
 
$album->display_upload_form($nb_file = 1); ?>      <?php class album
 
{
 
    var $user_id;
 
    var $size_limit = 100000;
 
    var $nb_limit;
 
    var $stored_pictures;
 
    function album($user_id, $nb_limit = 5)
 
    {
 
        $this->user_id = $user_id;
 
        $this->nb_limit = $nb_limit;
 
        $this->size_limit = $size_limit;
 
    }
 
    function display_album()
 
    {
 
        $q = "SELECT picture_id, name, size FROM picture WHERE user_id LIKE '".$this->user_id."'";
 
        $this->stored_pictures = mysql_query($q) or die(mysql_error()."<br />".$q);
 
        if(mysql_num_rows($this->stored_pictures))
 
        {
 
            print "<table border=\"1\">\n<tr><td align=\"center\"><b>Name</b></td><td align=\"center\"><b>Size</b></td><td align=\"center\"><b>Picture</b></td><td align=\"center\"><b>Action</b></td></tr>\n";
 
            while($d = mysql_fetch_row($this->stored_pictures))
 
            {
 
                print "<tr><td>".$d[1]."</td><td align=\"center\">".$d[2]."</td><td align=\"center\"><img src=\"pict/".$d[1]."\" /></td>";
 
                print "<td align=\"center\"><a href=\"".$_SERVER["PHP_SELF"]."?del_pict_id=".$d[0]."\">Delete</a></td></tr>\n";
 
            }
 
            print "</table>\n";
 
        }
 
        else
 
            print "<p>No picture ! </p>\n";
 
    }
 
    function store_picture()
 
    {
 
        //$_FILE is a superglobal so you can get it from there
 
        foreach ($_FILES as $file)
 
        {
 
             print "<p>".$file['name']."<br />";
 
            print "temp :".$file['tmp_name']."<br />";  
 
            print "type :".$file['type'] ."<br />";  
 
            print "size :".$file['size'] ."<br />";
 
            print "error :".$file['error'] ."</p>";
 
            if($file['size'] >= $this->size_limit)
 
            {
 
                print "<p>failed ".$file['name']." ".$file['size']." bytes : picture too heavy !</p>";
 
                return false;
 
            }
 
            if(preg_match("#^([a-z0-9_]+[.](jpg|gif))#i", $file['name']))
 
            {
 
                $q = "INSERT INTO picture (picture_id, name, size, user_id) VALUES ('', '".$file['name']."', '".$file['size']."', ".$this->user_id.")";
 
                mysql_query($q) or die(mysql_error()."<br />".$q);
 
            }
 
            else
 
            {
 
                print "<p>failed ".$file['name']." : Wrong picture name or extention !</p>";
 
                return false;
 
            }
 
            if(file_exists("pict/".$file['name']))
 
                $file['name'] .= $this->user_id;
 
            copy($file['tmp_name'], "pict/".$file['name']);
 
        }                
 
    }
 
    function delete_picture()
 
    {
 
        $q = "SELECT name FROM picture WHERE picture_id=".$_GET["del_pict_id"];
 
        $r = mysql_query($q) or die(mysql_error()."<br />".$q);
 
        $d = mysql_fetch_row($r);
 
        $file = "pict/".$d[0];
 
        $q = "DELETE FROM Picture WHERE picture_id=".$_GET["del_pict_id"]." LIMIT 1";
 
        mysql_query($q) or die(mysql_error()."<br />".$q);
 
        if(file_exists($file))
 
            unlink($file);  
 
    }
 
    function display_upload_form($nb_file = 1)
 
    {
 
        if(!$this->nb_limit <= mysql_num_rows($this->stored_pictures))
 
        {
 
            print "<form method=\"post\" enctype=\"multipart/form-data\" action=\"".$_SERVER["PHP_SELF"]."?up=1\">\n";
 
            for($i = 0;$i < $nb_file;$i++)
 
                 print "<p>\nPicucture N°".($i + 1)." : <input type=\"file\" name=\"file".$i."\" size=\"30\"></p>";
 
             print "<input type=\"submit\" value=\"upload\" />\n";
 
        }
 
        else
 
            print "<p>no more upload allowed !</p>";
 
    }
 
} ?>

//...
 
function store_picture()  
 
    {  
 
        //$_FILE is a superglobal so you can get it from there  
 
        foreach ($_FILES as $file)  
 
        {  
 
             print "<p>".$file['name']."<br />";  
 
            print "temp :".$file['tmp_name']."<br />";  
 
            print "type :".$file['type'] ."<br />";  
 
            print "size :".$file['size'] ."<br />";  
 
            print "error :".$file['error'] ."</p>";  
 
            if($file['size'] >= $this->size_limit)  
 
            {
 
               /* HERE I'M ALSO ECHOING THE MAX SIZE SET! $this->size_limit */
 
                  print "<p>max size set : ".$this->size_limit."</p>";
 
                print "<p>failed ".$file['name']." ".$file['size']." bytes : picture too heavy !</p>";  
 
                return false;  
 
            }  
 
            if(preg_match("#^([a-z0-9_]+[.](jpg|gif))#i", $file['name']))  
 
            {  
 
                $q = "INSERT INTO picture (picture_id, name, size, user_id) VALUES ('', '".$file['name']."', '".$file['size']."', ".$this->user_id.")";  
 
                mysql_query($q) or die(mysql_error()."<br />".$q);  
 
            }  
 
            else  
 
            {  
 
                print "<p>failed ".$file['name']." : Wrong picture name or extention !</p>";  
 
                return false;  
 
            }  
 
            if(file_exists("pict/".$file['name']))  
 
                $file['name'] .= $this->user_id;  
 
            copy($file['tmp_name'], "pict/".$file['name']);  
 
        }                  
 
    }