unknown error?

[lukeurtnowski]

I'm trying to upload 6 images to a select directory, but when I run the code, I get a strange error?
Error:Column count doesn't match value count at row 1

heres the php code

$uploaddir = "/images/ASP_Images";

$currentname1 =  $_FILES['Image1']['name'];
$currentname2 =  $_FILES['Image2']['name'];
$currentname3 =  $_FILES['Image3']['name'];
$currentname4 =  $_FILES['Image4']['name'];
$currentname5 =  $_FILES['Image5']['name'];
$currentname6 =  $_FILES['Image6']['name'];

$Photo1 = $currentname1.date("Ymdhis");
$Photo2 = $currentname2.date("Ymdhis");
$Photo3 = $currentname3.date("Ymdhis");
$Photo4 = $currentname4.date("Ymdhis");
$Photo5 = $currentname5.date("Ymdhis");
$Photo6 = $currentname6.date("Ymdhis");


if(is_uploaded_file($_FILES['Image1']['tmp_name']))
{
move_uploaded_file($_FILES['Image1']['tmp_name'], $uploaddir.'/'.Photo1);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo1 . "></p>"; 
}
if(is_uploaded_file($_FILES['Image2']['tmp_name']))
{
move_uploaded_file($_FILES['Image2']['tmp_name'], $uploaddir.'/'.$Photo2);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo2 . "></p>";
}
if(is_uploaded_file($_FILES['Image3']['tmp_name']))
{
move_uploaded_file($_FILES['Image3']['tmp_name'], $uploaddir.'/'.$Photo3);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo3 . "></p>";
}
if(is_uploaded_file($_FILES['Image4']['tmp_name']))
{
move_uploaded_file($_FILES['Image4']['tmp_name'], $uploaddir.'/'.$Photo4);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo4 . "></p>";
}
if(is_uploaded_file($_FILES['Image5']['tmp_name']))
{
move_uploaded_file($_FILES['Image5']['tmp_name'], $uploaddir.'/'.$Photo5);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo5 . "></p>";
}
if(is_uploaded_file($_FILES['Image6']['tmp_name']))
{
move_uploaded_file($_FILES['Image6']['tmp_name'], $uploaddir.'/'.$Photo6);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo6 . "></p>";
} 

Thanks...

[sneakyimp]

row 1? that doesn't sound like a PHP error to me...sounds like something generated by a module or class you might be using. php errors usually have a line number in the code.

maybe the code you are showing us isn't at fault?

[lukeurtnowski]

found the problem, my field count didn't match up wwith a row in my database.
Now, why, when I run the page is no image shown shouldn't one

$uploaddir = "/images/ASP_Images/";

if(is_uploaded_file($_FILES['Image1']['tmp_name']))
{
$currentname1 =  $_FILES['Image1']['name'];
$Photo1 = $currentname1.date("Ymdhis");
move_uploaded_file($_FILES['Image1']['tmp_name'], $uploaddir.'/'.Photo1);
echo "<p><b>Image1:</b><img src=".$uploaddir.'/'. $Photo1 . "></p>"; 
}

I submitted a prefilled form, here is an example of an attachment

$message .= 'Attachment 1: <input type="file" name="Image1" value="' . $Image1_name . '"><br />';

but for some reason, it never has a value

$Image1_name = $_FILES['Image1']['name'];

Even when I upload an image.
Thanks..

[Houdini]

This is an SQL error

Error:Column count doesn't match value count at row 1

This means there are more columns than values in a query or viceversa.

"INSERT INTO members (firstname, lastname, email, city, state)  VALUES ('George', 'Jetson', '[e-mail]' , 'Cartoonville', 'California', '47113')"; 

Would give a similar error becuase there is a value provided for a column that was not listed.

[sneakyimp]

'module' could in fact refer to other php that you have included() in your code.

my point was that you didn't show us all the relevant code and the code you did show us usually doesn't make errors like that. php errors usually tell you what line number is causing the problem.

yes it could definitely be database-related code. in fact, it sounds like an sql error that occurs when you say something like

INSERT INTO TABLE_X (column1, column2, column3) VALUES (value1, value2)

the problem is that you specified 3 columns and only 2 values.

[sneakyimp]

yeah like houdini said...

i personally find it easier to keep track of INSERT statements when you do it like this

INSERT INTO TABLE_X
SET column1=value1,
column2=value2,
column3=value3

[lukeurtnowski]

ok, thanks all