I am trying to create a php-mysql page to POST new records to several tables from one php page and I have to retrieve records from several (like 4 to 8) tables in one query. Being quite new to php & mysql, I am wondering what is the best way to go about this. My tables consist of
* Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=authors&goto=tbl_structure.php> authors <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=authors&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=books&goto=tbl_structure.php> books <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=books&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_author&goto=tbl_structure.php> book_author <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_author&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_categories&goto=tbl_structure.php> book_categories <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_categories&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_publisher&goto=tbl_structure.php> book_publisher <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_publisher&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_sellers&goto=tbl_structure.php> book_sellers <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=book_sellers&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=categories&goto=tbl_structure.php> categories <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=categories&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=language&goto=tbl_structure.php> language <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=language&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=publishers&goto=tbl_structure.php> publishers <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=publishers&pos=0> * Structure <http://biggie/phpmyadmin/tbl_structure.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=sellers&goto=tbl_structure.php> sellers <http://biggie/phpmyadmin/sql.php?db=biblane&token=6b20581bf9be2fb146f60d93cc87a296&table=sellers&pos=0> On top of this, I have a problem of how to deal with multiple authors for a number of books... formatting a page with several authors is not a prolem... but how do I POST and SELECT several authors for the same book? Categories is a similar problem... And then, there is the question of language - books are included from 5 different languages... This, I thought, could be handled by referencing the language table by the PK of the language table which is obviously numbers from 1 to 5 I am beginning to see the light... but I sure would like to shorten my learning curve by asking here... I would like to see examples, if possible. I have no problem formatting and outputting a great page from a simple SELECT * FROM my_table... but when it comes to querying several tables plus needing to do something like left joins, I am a little lost. How to do a multi-table query or how does one do several queries from one php page? How can multiple POSTs be done on one php page? TIA -- Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org