OUTFILE --where to search..PL help me

[Anon]

hello folks,
when i execute the following query..
I couldnt able to trace whether file has been created or query failed!!!!!!!!!!
please help me out..
where should i check for outfile?
how do i know whether its been created or not?

mysql_query("select * INTO OUTFILE 'write_2_file' from counter where wo = '$wo'",
$db);

Your help is greatly appreciated

maruti

[Anon]

I think you will find the file in your mysql data directory.

Otherwise you can probably specify a file path like for example:

mysql_query("SELECT * INTO OUTFILE 'C:\windows\desktop\write_2_file.txt' FROM counter WHERE wo = '$wo'", $db);

You must escape the backslashes.

[shastry]

Hi Srinivas,
Try with this..
$query="select * INTO OUTFILE 'write_2_file' from counter where wo = '$wo'";

if (!mysql_query($query,$dbLink))
{

        DisplayErrMsg(sprintf("Error in executing %s stmt", $stmt)) ;
        DisplayErrMsg(sprintf("error:%d %s", mysql_errno($dbLink), mysql_error($dbLink))) ;
        exit() ;
    }

else
{
print "Your file has been created..";
exit();
}
..where $dbLink is your db_connection Handler..

function DisplayErrMsg( $message )
{
printf("<blockquote><blockquote><blockquote><h3><font color=\"#cc0000\">
%s</font></h3></blockquote></blockquote></blockquote>\n", $message);
}

--Shastry