| agore | joseAway: its windows that your on ? |
| joseAway | Yep. Using the xampp package |
| agore | is it not hiding .ini files when you do your search ? |
| dim | hi all, need some help. I tried checking your wiki site but i'm not a developer and couldn't figure out how to combine queries for what I need... (I have 3 tables in my DB which I need to query for products. DB (mystoredb), tables (products, products_description, manufacturers) I need to export a list of products with certain fields from each table. what's the sql query please? |
| joseAway | agore, it's searching hidden files and folders.. |
| agore | all mysql on linux and windows have this config file unix its my.cnf and windows its my.ini |
| joseAway | They should :| But mine appears to be missing How could it start without my.ini? |
| agore | Ive never tried :) but perhaps it can ? and uses defaults |
| joseAway | Ah. Blame xampp. |
| jhansen | dim: you need to know the query only, or how to export it as well? in what format? |
| joseAway | It's executed in a batch file with the line mysql\bin\mysqld --defaults-file=mysql\bin\my.cnf --standalone --console |
| dim | i have access to phpMyAdmin, so I can just paste query in there.. |
| agore | ah cool so if you edit my.cnf |
| dim | each product ias information that I need in all 3 tables (products, products_description, and manufacturers) has* from the "products" table I need - products_alternate_name & products_description fields sorry, this ^^^ was the products_description table and from the "products" I need - products_model, products_image, products_price |
| joseAway | Well, I tried setting the default character set... but no dice. I think I'll just remove what I have in the way of mysql libs and servers and get them all the same version this time |
| jhansen | dim: SELECT p.*, pd.name, m.name FROM products p, producut_descriptions pd, manufactures m WHERE p.id = pd.product_id AND p.manufacutired_id = m.id; |
| agore | joseAway: you need to rebbot mysql |
| dim | the "products" table has a manufacturers_id field, which is linked to the "manufacturers" table |
| agore | restrat mysql for the my.cnf file to take effect |
| jhansen | dim: spell check |
| joseAway | Yes, I did :\ |
| agore | joseAway: worth a try :) |
| joseAway | indeed |
| dim | thank you, let me try it jhansen |
| joseAway | thanks for all the help agore |
| agore | np good luck |
| linagee | cool! woops. wrong chan. :) |
| carrera | has anyone compiled php-5-2-2 with mysql-5.0.37-linux-i686 i get mysql errors |