Hi, On Fri, Feb 13, 2009 at 4:52 PM, PJ <af.gour...@videotron.ca> wrote: > 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&;
Your links don't work for me, and I suspect anyone else on this list. And it may be asking too much of people to click through 40 or so links -- you probably need to ask your question more succinctly to get the best chance of an answer. > 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 -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
