Import text data into mysql

Anon

I am getting this error:
Invalid DATA LOAD query

here is a sample of the text in the text file:
steve,123-456-0000

Here is all my code:

MySQL database User ID, Password and DB name

$database_login="";
$database_pass="";
$database_host="localhost";
$database_name="";
$db=mysql_pconnect($database_host,$database_login,$database_pass);
mysql_select_db($database_name,$db);

Load local comma separated, fields enclosed by quotes text database - File has to be in the same directory of this file

$result = mysql_db_query('$database_login',"LOAD DATA INFILE 'test.txt' INTO TABLE news (user,phone) FIELDS TERMINATED BY ','") or die ("Invalid DATA LOAD query");

I would also like to automatically with each import, put a category # in. We have different user classes. I will have multiple text files for each class. (user,phone, cat_id=4)

Can i do something like that? it is not possible to add the cat_id into the text file.

Please help guys,
Thanks

Anon

$result = mysql_db_query('$database_login',"LOAD DATA INFILE 'test.txt' INTO TABLE news (user,phone) FIELDS TERMINATED BY ','") or die ("Invalid DATA LOAD query");

it may just be ME, but according to your code the '$database_login' in the above statement should be $db.

Anon

I tried, $db still same error.

[deleted]

Take out the 'or die' , and do something like:

if (!$result = mysql_query(bladebla load ata infile"))
{
echo mysql_error();
};

That will tell you exactly what's wrong with your query, and I think you'll find that it is MySQL that loads the file, not PHP, so you have to put the full path to the test.txt file in the query.

psr540

you might need local keyword

Anon

$result = mysql_db_query('binnews_bins',"LOAD DATA local INFILE 'test.txt' INTO TABLE news FIELDS TERMINATED BY ',' (user,phone) update news set category_id=3");

OK, i got the import working, but i still need to update the category_id. Like I said, i am unable to have that in the import text file. Thanks guys, so far..almost there.

[deleted]

After the import, all fields that were not filled by the import will be NULL, so you could do

UPDATE table SET category_id=3 WHERE category_id IS NULL;

but be carefull, if you do two imports without updating the category inbetween them, you will have no way of knowing which records should get category_id=3 and which records should get category_id=4!

Anon

Thanks guys, you were a HUGE help.

Importing is working