I've already scoured google in relation to this issue and so far have found many solutions, none of which seems to work.

PHP 4
MySQL 4.1.20

The script I'm working on at the moment returns a MySQL error : Unknown column 'column_name' in 'field list' Where column_name can be any valid column for the table. I've changed the order and the query insert style several times, restarted the MySQL server, and various other rain dances, all with the same results.

Here's a brief overview of the query that the script generates, it works fine when run directly in MySQL so I'm guessing there's something funny going on with the PHP/MySQL interface.

( query behind the cut along with errorCollapse )

Any ideas anyone? I generally try and hammer these things out on my own but this one's just too busy givnig me a migraine after working on it for so long. Still with no idea how to start on it.

I'm at a loss for what is causing this error and not moving an uploaded file, if someone could take a look at the code and see what I might be missing would be appreciated,
here is the output:
Upload: 617.txt
Type: text/plain
Size: 8.900390625 Kb
Stored in: /tmp/phpMhLXr8
Warning: move_uploaded_file(1/617.txt): failed to open stream: No such file or directory in /mnt/w0701/d15/s12/b0287a72/www/[domain].org/playlist/upload_file2.php on line 18

Warning: move_uploaded_file(): Unable to move '/tmp/phpMhLXr8' to '1/617.txt' in /mnt/w0701/d15/s12/b0287a72/www/[domain].org/playlist/upload_file2.php on line 18
Stored in: 1/617.txt1

and the code block:


{
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "
";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "
";
echo "Type: " . $_FILES["file"]["type"] . "
";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb
";
echo "Stored in: " . $_FILES["file"]["tmp_name"];

$path = mkdir ("./" . date("YMDHis"), 0777);
move_uploaded_file($_FILES["file"]["tmp_name"], $path . "/" . $_FILES["file"]["name"]);
echo "Stored in: " . $path . "/" . $_FILES["file"]["name"];
echo $path;
}
}


Anyone have any idea why after establishing a pconnect with my MySQL server previously in the script when I try and run a query later on (without closing the connection) it throws the following error :

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\AppServ\www\movies_dev\movies.php on line 18

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\AppServ\www\movies_dev\movies.php on line 18

Ignore the line numbers infront of the code behind the cut, I pasted it on a pastebin and it threw it's own line numbers in and I don't have the time to cut them out.

( 2 files and errorCollapse )