#3316 [Opn->]: problem with select into outfile from php3

ID: 3316 Updated by: hholzgra@php.net Reported By: libes@com.univ-mrs.fr -Status: Open +Status: Won\'t fix Bug Type: MySQL related Operating System: linux redhat6.0 PHP Version: 3.0.14 New Comment: We are sorry, but can not support PHP 3 related problems anymore. Momentum is gathering for PHP 5, and we think supporting PHP 3 will lead to a waste of resources which we want to put into getting PHP 5 ready. Ofcourse PHP 4 will will continue to be supported for the forseeable future. Previous Comments: ------------------------------------------------------------------------ [2000-01-26 07:52:43] libes@com.univ-mrs.fr hi to all.. in a previous message you tell me to use "select ... into outfile" query in order to get database result into a file! I try this query from MySQL with success BUT... i do not succeed anything (or get the result file) when launching it from a PHP3 script in the example below we do succeed to write a text file in /home/ftp/pub (so the user rights seems to be good (our http apache demon runs under httpd user and group , and /home/ftp/pub belong to httpd group with 775 permissions) BUT... the same thing from a PHP3 script launching a query select into outfile /home/ftp/pub " no not succeed (the file is not created... and i really don't know why!! what can be wrong??? thanks for your help ---------- <?php $base="PNOC"; $userpnoc="httpd"; $host="localhost"; $passwd="*****"; $connect=mysql_connect($host,$userpnoc,$passwd); $fd=fopen("/home/ftp/pub/titi.txt","w"); /* file is created !!!!*/ $query="select * from mission into outfile \"/home/ftp/pub/bidon\";"; /* file bidon is NOT created !!! */ $result=mysql_db_query($base, $query); ------------- ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=3316&edit=1