Sock Puppet

This should do what you want: select d.domain_name, k.keyword from domains as d, keywords as k, pages as p where d.id=p.id_domain and k.id=p.id_keyword order by p.id_domain The only difference from yours is order by instead of group by. It won't be exactly the format you described, but it should be easy to write some php that works with these results. They'll look like: - domain name, keyword in domain - domain name, keyword in domain - domain name, keyword in domain - domain name, keyword in domain - domain name, keyword in domain Because of the order by clause though, all the records for a given domain id will be grouped together in your result set, which is (mostly) what you wanted.

Databases are made to deal with huge amounts of data. If you create indexes on the columns you'll be using as selection or join criteria, it should be fine for you.

Your subquery needs to be a valid SQL query in itself. This should probably work for you. INSERT INTO node (nid, vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) (SELECT moj_id, moj_id, 'mojocd', 'en', moj_title, 0, 1, 1293671713, 1293671713, 0, 0, 0, 0, 0, 0 FROM mojocd)

Unless I'm mistaken, ZipArchive::extractTo returns true on success and false on failure. You should be able to just do this: $success = $zip->extractTo($_SERVER['DOCUMENT_ROOT']."/update/temp/$update"); $zip->close(); echo "Extraction started."; if($success) { installupdate($update); } else { echo "Error during extraction."; }