INSERTING from OPENDIR()

[Anon]

It seems I am doing something incorrect

while($file = readdir($main)) {
if ($file != "." && $file != "..") {
$query = "insert into tblamateur values
($file)";
$query_result_handle = mysql_query ($query);
}
}

I think it's where the $file from the insert statement that is not working because if I put 'test' instead of $file, it inserts...any comments ?

Thanks

[bigc79]

shouldn't you be saying???

while($file == readdir($main))

before you were assigning $file to the value of readdir($main)) you weren't checking to see if it was the same value

As Always

Clive

TeachingU wrote:

It seems I am doing something incorrect

while($file = readdir($main)) {
if ($file != "." && $file != "..") {
$query = "insert into tblamateur values
($file)";
$query_result_handle = mysql_query ($query);
}
}

I think it's where the $file from the insert statement that is not working because if I put 'test' instead of $file, it inserts...any comments ?

Thanks

[kparker]

You're leaving off the single quotes around '$file'.

But this brings up a bigger issue: why aren't you checking the return value of the query and displaying mysql_error() if it fails? That way, you'd have already known what was wrong. :-)

[[deleted]]

Nope,

while ($file=readdir($main))

means:

make $file equal to readdir($main)
and continue if $file is still true (non-zero)