simcoweb Posted July 18, 2006 Share Posted July 18, 2006 Here's the code designed to create a CSV file from the MySQL results:[code]$data = "";$result = mysql_query("SHOW COLUMNS FROM `iplog`") or die(mysql_error());while($row = mysql_fetch_array($result)) { $data .= $row[0].",";}$data = substr($data,0,-1)."\r\n";$result = mysql_query("SELECT * FROM `iplog`") or die(mysql_error());while($row = mysql_fetch_assoc($result)) { foreach($row as $r) { $data .= "$r,"; } $data = substr($data,0,-1)."\r\n";}$handle = fopen("data.csv","wb");fwrite($handle,$data);fclose($handle);[/code]The way this works right now is it writes the 'data.csv' file to the same folder the script(s) are in which means, on my servers, I have to set permissions to 777 for that to work. What I want to do is have it write the 'data.csv' file to a sub-folder so I can set the permissions on that to 777 and not have to worry about it. Right now it writes like this:/iplog/data.csvI need:/iplog/csv/data.csvThanks! Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted July 18, 2006 Share Posted July 18, 2006 change:[code]$handle = fopen("data.csv","wb");[/code]to [code]$handle = fopen("./subfolder/data.csv","wb");[/code] Quote Link to comment Share on other sites More sharing options...
simcoweb Posted July 19, 2006 Author Share Posted July 19, 2006 I knew it would be something simple. Thanks for the help! :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.