Please help

[d99kg]

$dbQuery="SELECT * FROM sale";
$result = mysql_query($dbQuery,$db);

while ($macInfo=mysql_fetch_array($result))
{
$productID=$macInfo["productID"];
$name=$macInfo["name"];
$dateBought=$macInfo["dateBought"];
$numBought=$macInfo["numBought"];

$out=fopen("fileCreateYourself.txt","a") or die ("file won't open");
fwrite($out,"Product ID = $productID	Name = $name	Date Bought = $dateBought	Num Of This Prod To Date = $numBought\n");

}

fclose($out);

This is my code to let me write to a txt file, but to do so I have to change my permissions within the database to chmod 777, is there any way I can include this command in the code, and the permissions just change every time I run this file???

Cheers

[khaldryck]

first i would put the fopen before the mysql_fetch_array();

then, all you have to do is to give read and write permissions to the user apache is running with.
(nobody by default), give those permissions to the directory where you want to write the file.
the file will be created with the default permissions for the user.
if you want to change them so that ecveryone can read, write or execute it, you can then call the system function to execute the chmod

see more about system in the php manual.

[BuzzLY]

For the record... if you want help with a problem, state the problem in your subject. Don't just put "Please help." Many people won't even look at a post that doesn't have a descriptive subject. Even "Help with permissions..." would suffice.