upload problem with database

[grlayouts]

i have an upload script that uploads the file fine. however it will not add the image to the database.

 

i have placed the bit of code below, any ideas?

 

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

[grlayouts]

ne1?

[mmarif4u]

Its not a good idea to store images in db.Store a link to image in db.

What specific error u getting.

[grlayouts]

none. it is the link i want to save in  the database??

 

but the image uploads fine. just not the database part?

[mmarif4u]

It mean u want to store a link in db for that picture.

So assign ur file name to a variable and then put in ur query to store.

[grlayouts]

why would i need to assign when i can use images/uploads/$Files[name].$files[extension]

 

??

[mmarif4u]

i mean assign it like this its easy to handle code.

 

$fileName = $_FILES['filename']['name'];

 

Than insert it like this:

 

$query = "INSERT INTO upload (name)VALUES ('$fileName')";