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 --- [email protected]
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/[email protected]
