Exporting Mysql data to a text file

[rlobianco]

Hi, I'm trying to export data from my mysql database to a text file using the 'INTO OUTFILE" funtions. If I run the query command using the mysql interface it works fine but whey I try to use it in a simple PHP script with the mysql_query command no files are written.

I'm running the PHP script as root for testing and also the DB user has all mysql privileges and the /tmp directory has write permissions, etc.

Here's the PHP script I'm using.. Maybe someone can see what I'm doing wrong?

<?php 

  // Database Settings 
  $dbhost = "localhost";
  $dblogin = "root";
  $dbpwd = "password";
  $dbname = "cart";

mysql_query ("SELECT `cart_products`.`product_code` FROM cart_products WHERE `supplier_id` = 26 into outfile '/tmp/cart_items.txt'");
?>

Thanks in advance for any help you can provide..

Ralph

[NogDog]

I've not tried that from within PHP, so don't know if there are any restrictions. But the first thing I'd try is checking if mysql_error() says anything "interesting" after your run the mysql_query().

[rlobianco]

LoL, sometimes its the simple stuff that I just seem to overlook when I get way to tired..

This code works...

<?php 

  // Database Settings 
  $dbhost = "localhost";
  $dblogin = "root";
  $dbpwd = "password";
  $dbname = "cart";

 echo "Database Connection Test\r";
  mysql_connect($dbhost, $dblogin, $dbpwd) or die ("Could not connect to database.\r");
  mysql_select_db($dbname) or die('Could not select database.\r');

mysql_query ("SELECT `cart_products`.`product_code` FROM cart_products WHERE `supplier_id` = 26 into outfile '/tmp/cart_items.txt'");

?>