Access Denied !!

From: Date: Fri, 15 Feb 2002 13:58:18 +0000
Subject: Access Denied !!
Groups: php.general 
Request: Send a blank email to php-general+get-84901@lists.php.net to get a copy of this message
Hi, I'm facing a rather tricky problem. The thing is, while connecting to the mySQL database using my php page, i get the "acess denied" error on only One Particular command, and on any other query, the same page, with the same login details works fine! For ex, this works fine : <?php $db = mysql_connect("localhost","m","pwd"); mysql_select_db("m",$db); $sql = "CREATE table try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), PRIMARY KEY (ID))"; $result = mysql_query($sql); echo "Thank you! Your information has been entered.\n"; ?> But this gives an "Access Denied" error : <?php $db = mysql_connect("localhost","m","pwd"); mysql_select_db("m",$db); $query = "LOAD DATA INFILE 'fanlist.csv' INTO TABLE try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'"; mysql_query($query) or die("error:". mysql_error()); ?> Why is this happening? T. Edison jr. ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastech@yahoo.com Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com

« previous php.general (#84901) next »