php mysql image name into database

[Vince_M]

I am working on a php file for school. We have to take a form and add first name, last name, email and a photo to a database. I am able to add the names, email to the database but am unable to add the image name to the database. Here is part of the php code and some of the html. If someone can please take a look and give some help. Many thanks in advance.

<?php include("db_connect.php");?>
<?php // select the database in which to add a table
mysql_select_db("final_exam_db",$con);



$sql ="INSERT INTO drivers_0115061 (ln,fn,month,day,year,photo,email)
VALUES ('".$_POST["ln"]."',
'".$_POST["fn"]."',
'".$_POST["month"]."',
'".$_POST["day"]."',
'".$_POST["year"]."',
'".$_POST['file']['photo']."',
'".$_POST["email"]."'
)";

//$sql="INSERT INTO people (fn,ln,dob,city,prov,pc,gender,hc,nod) VALUES ('steve','douglas',1234567,'winnipeg','manitoba','r3p 6g5','m','grey',2)";

//echo $sql;


mysql_query($sql, $con);
echo mysql_error();
?>




<?php include("db_close.php");?>

HTML:
<td>
Picture
</td>
<td>
<input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>
<input type="file" id="photo" name="photo"/>
</td>
</tr>
<tr>
<td>

[NogDog]

Start by looking at this "sticky" post at the top of this forum: http://www.webdeveloper.com/forum/sh...ages-using-PHP