Upload script not working...please help?

[sayimcrisp]

ok so im new to this but here is a script i threw together.I am trying to upload a video and add the title, runtime(length), description, and keywords to the database but so far no luck on making this work. can someone please help me get this working? and also if I add a field in the form to upload a image to use as a thumbnail later, how you I add $image to this so it can upload in the same folder?

//This is the directory where videos will be saved 
$target = "media/videos/"; 
$target = $target . basename( $_FILES['video']['name']); 

//This gets all the other information from the form 
$title=$_POST['title']; 
$description=$_POST['description']; 
$runtime=$_POST['runtime']; 
$keywords=$_POST['keywords']; 
$video=($_FILES['video']['name']); 

// Connects to your Database 
include_once ("../include/connect_to_mysql.php"); 

//Writes the information to the database 
//ad all the details to database
$query = "INSERT INTO videos (dateAdded, title, runtime, description, video, keywords) VALUES (now(), '$title', '$runtime', '$description', '$video', '$keywords')";
$results=mysql_query($query);

//Writes the video to the server 
if(move_uploaded_file($_FILES['video']['… $target)) 
{ 

//Tells you if its all ok 
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
} 
else { 

//Gives and error if its not 
echo "Sorry, there was a problem uploading your file."; 
} 

[sayimcrisp]

when using the form, if I leave the video field empty, everything else (title, desc, keywords) is posted to database table. BUT, if I enter a video file along with all the other information, nothing uploads at all. the form takes the title, description, keywords, runtime (length), and file (which would be avideo).

---

//This is the directory where videos will be saved 
$target = "media/videos/"; 
$target = $target . basename( $_FILES['video']['name']); 

//This gets all the other information from the form 
$title=$_POST['title']; 
$description=$_POST['description']; 
$runtime=$_POST['runtime']; 
$keywords=$_POST['keywords']; 
$video=($_FILES['video']['name']); 

// Connects to your Database 
include_once ("../include/connect_to_mysql.php"); 

//Writes the information to the database 
//ad all the details to database
$query = "INSERT INTO videos (dateAdded, title, runtime, description, video, keywords) VALUES (now(), '$title', '$runtime', '$description', '$video', '$keywords')";
$results=mysql_query($query);

//Writes the video to the server 
if(move_uploaded_file($_FILES['video']… $target)) 
{ 

//Tells you if its all ok 
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
} 
else { 

//Gives and error if its not 
echo "Sorry, there was a problem uploading your file."; 
}

[dagon]

add error checking to the mysql_query() and sanitise all user inputs.