Yemi,
For a first debugging step, have php print out the $sql variable to a
screen. Then copy and paste that to a mysql client, and make sure you
get the same error. That's good to debug any script -- make sure the
query that the script is doing can actually run. Sometimes it's in
how php parses scripts and such.
-Sheeri
On 10/20/05, 'Yemi Obembe <[EMAIL PROTECTED]> wrote:
> i'm having a problem with the load data infile command...i'm actually running
> the script from a php script that goes this way:
> <?php
> mysql_connect("localhost", "$user", "$pass");
> mysql_select_db("ng");
> $sql = "load data local infile 'movies.txt' into table dir fields terminated
> by '|'";
> if($res = mysql_query($sql))
> echo "loaded";
> else
> echo mysql_error();
> ?>
>
> the script and the txt file movies.txt reside on the same directory. runnign
> the page, i get the error: The used command is not allowed with this MySQL
> version
> my mysql version is 4.2.2
> what could be wrong? by the way, i'v tried changing the movies file path to a
> full path but still doesnt change things.
>
>
>
> ---------------------------------
>
> A passion till tomorrow,
> Opeyemi Obembe | ng.clawz.com
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
