[gtg]

I am a total newbie to programming..so having a hard time as an intern
I tried to create a program that can export data from mysql into an ___.input file (tab delimited file) for use on amazon mech turk.

Now, this is my program (unsure if it is fully correct)
__________________________________________________ _______________

PHP Code:

<?php
$HIT_SIZE=20;
$MIN_ID=901;
$MAX_ID=1200;

$host= "*****";
$user = "****";
$pass = "******";
$database = "***";
$designClass="D6";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query1="SELECT * from patent_extract";
$result = mysql_query($query1) or die("Could not carry out query");

$fp = fopen("patentnum.input", "a")or die("can't open file"); 

while($row = mysql_fetch_array($result)) { 
fwrite($fp, "insert into table ".
"values ('$row[col1]', '$row[col2]','$row[col3]')\n");
}

fclose($fp); 
?>

__________________________________________________ _______________

And when I try to run the php script in Windows cmd, ( C:/PHP/PHP.EXE -f c:/users/gtg/desktop/yes.php)

I get this message...

"Warning: fopen(patentnum.input): failed to open stream: Invalid argument in C:\Users\gtg\Desktop\yes.php on line 18 "

1) Is my program correct?
2) Why can't I open the file?

Thanks!

[algorithmetics]

Try specifying whether to open the file in text or binary mode, e.g.

PHP Code:

fopen("patentnum.input","ab") 

or

PHP Code:

fopen("patentnum.input","at") 

Binary mode is better for portability reasons: http://www.php.net/fopen