help how export products price plus name into csv

[mhpo]

hello first of all sorry for my crapy english any way :

i want to export "product" table to csv to edit it from excel it much more eazy coz i got all mine products plus prices how eazy is that but ican't i made a little php code that export the product table from my sql to csv so now i can download the csv file with all the information from table "products" so now i can edit the price the model name pictures etc.. but the thing im also most need is beside price model name and pictures is the "name of the products wich im not have in the "products" table its inside the "categories_description" table is there any way to export csv file with 2 tables for example :

 

the first 3 columns from table named : `"categories_description" this table have only categories_id language_id categories_name and all the other columns will be from table "products" and export all this into one csv file so i can download this csv and chane price name of the products and etc from one file but when i will upload it will know where to dump first 3 columns into one table and all the others in other is there any way to do that becous from excel menage the products its so much better if i have alot of products and need to update prices or name of group of some products.

 

p.s if ther is any way only without the phpMyadmin i want php script to do the import and the export

Edited April 15, 2008 by mhpo