mysql_query basic question?

[abcd1234]

hi people.

<?php

      *** more codes here ***

			$new_id = mysql_insert_id();
			$filetype = $photos_uploaded['type'][$counter];
			$extension = $known_photo_types[$filetype];
			$filename = $new_id.".".$extension;
			$filename2 = $photos_uploaded['name'][$counter];
			$filesize = $_FILES['size']['$counter'];

mysql_query("INSERT INTO photos(`photo_filename`, `filetype`, `size`, 'date')
VALUES($filename2, $filetype, $filesize, day())");


        *** more codes here ***

?>

hi there, is there something wrong with my mysql_query expression?

thanks in advance

[Houdini]

You asked about your query, and here is my suggestion for the most of it, not too sure show your date field is set up but here is what you can try, you need to quote your variables except numbers or integers and CURDATE is one of them.

mysql_query("INSERT INTO photos(`photo_filename`, `filetype`, `size`, 'date')VALUES('$filename2', '$filetype', '$filesize', CURDATE())";

also I would do the query this way to check what PHP and MySQL see by this

$query="INSERT INTO photos(`photo_filename`, `filetype`, `size`, 'date')	VALUES('$filename2', '$filetype', '$filesize', CURDATE()";
echo $query; //then execute the query 
$result=mysql_query($query)
  or die("Could not execute the query. MySQL said: ".mysql_error());