Insert Items to database

[doenci]

I know how to insert items to the database one by one.
But I'd like to insert more than one at the time.
I need some function to run i guess. TIL ....
Please help

Tamas

[hessian]

I am not aware of any one to insert more than one row with an Insert.

You just need an Insert in a loop..

Where are you getting the data you want to insert. Is this a one time thing?

If it is a one time thing, mysql can load from a file.

[doenci]

yes I guess I need a loop
so if I have this code...

INSERT INTO products_description (products_id, language_id, products_name, products_description)
VALUES (1723,1,'TexMex Corn Dog 1+oz','90 Pack/Case')

... I'd like to add more rows with values at one time

What loop I need in this case?

I had exported a access file into text

I tried to upload it with mysql , but I guess the version i have is not able to do it, MySQL 3.23.58

thank you for the help

[hessian]

I am assuming you have a comma delimited file.

$file = fopen("/path/your.csv","r");
while($line = fget_csv($file,1000,","))
{
$sql = "INSERT INTO products_description (products_id, language_id, products_name, products_description)
VALUES
('".mysql_real_escape_string($line[0])."','".mysql_real_escape_string($line[1])."',"'.mysql_real_escape_string($line[2])."','".mysql_real_escape_string($line[3])."')";
mysql_db_query("$DB_NAME",$sql);
}
fclose($file);

You may have to add a forth argument for the fget_csv, and let it know the encloser char.

But I think you should be able to import files from the command line. Are you using mysql_front? I think mysql_front has a bug in file load.

[doenci]

i try to upload thru the text file, but still no success.
i use phpmyadmin to do mysql, i'm not sure if it mysql_front or not...
i tried the code but I received errors

Error

SQL-query :

$file = fopen(

"D:\Documents and Settings\Tamas\Desktop\Products.txt", "r"
)

MySQL said:

You have an error in your SQL syntax near '$file = fopen("D:\Documents and Settings\Tamas\Desktop\Products.txt","r")' at line 1
Back

[hessian]

D:\Docume~1\Tamas\Desktop\Products.txt

Escape the backslashes when in windows and avoid using long file names.