[SOLVED] upload problem

[grlayouts]

the code i have uploads the file ok but it's not placing the images location into the database. the error i get is Could not update database". but i cant see the problem?

 

move_uploaded_file($_FILES["file"]["tmp_name"],
      'uploads/'. $_FILES["file"]["name"] .'');
      echo "Stored in: " . "uploads/" . $_FILES["file"]["name"];
  print '<p>'.$type.'</p>';
  $fileName = $_FILES['file']['name'];
  mysql_query("insert into images (user, image) values('$stat[id]','$fileName')") or die("Could not update database.");
      }
    }
  }

[chigley]

For starters, where do you define $stat[id]?

 

<?php

move_uploaded_file($_FILES["file"]["tmp_name"],
      'uploads/'. $_FILES["file"]["name"] .'');
      echo "Stored in: " . "uploads/" . $_FILES["file"]["name"];
  print '<p>'.$type.'</p>';
  $fileName = $_FILES['file']['name'];
  mysql_query("insert into images (user, image) values('$stat[id]','$fileName')") or die("Could not update database: ".mysql_error());
      }
    }
}

?>

 

Run that and see what the mySQL error is.

[grlayouts]

sorry i had update user instead of ID.. thanks alot though.