[PHP-DB] More than 50 entries!!!
Hi, I must to do a Admin to insert 50 entries on a table. I solve it creating 4 tables in my PHPMyAdmin: 1) primary data 2) sec data 3) other data 4) pictures, almost 10 per product How do I do to insert the data about the same product in 4 tables, and then print them in the appropriate section on the web? How do I do, the SELECT, INPUT and UPDATE to the 4 tables? And how do I do a search with this 4 tables strucutre? Thanks a lot! + _ // Emiliano Boragina _ // Diseño Comunicación // + _ // emiliano.borag...@gmail.com / // 15 40 58 60 02 /// + _
Re: [PHP-DB] More than 50 entries!!!
assign every product an unique product id. this can be done by an auto increment value in the primary table, then use mysql_insert_id() to get the product id. thereafter use the unique product id to refer to the product (in the database tables) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] More than 50 entries!!!
why separate the products to 4 table? On Fri, Jul 10, 2009 at 4:54 PM, kranthi kranthi...@gmail.com wrote: assign every product an unique product id. this can be done by an auto increment value in the primary table, then use mysql_insert_id() to get the product id. thereafter use the unique product id to refer to the product (in the database tables) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Best Regards! Wen Dong
Re: [PHP-DB] More than 50 entries!!!
because 2,3,4 tables have one to many corespondence. (at least 4 table does)
Re: [PHP-DB] More than 50 entries!!!
On Fri, Jul 10, 2009 at 3:03 PM, kranthi kranthi...@gmail.com wrote: because 2,3,4 tables have one to many corespondence. (at least 4 table does) Every heard about SQL joins? -- Zareef Ahmed :: A PHP Developer in India ( Delhi ) Homepage :: http://www.zareef.net
Re: [PHP-DB] More than 50 entries!!!
On Sat, Jul 11, 2009 at 5:51 AM, Zareef Ahmed zareef.ah...@gmail.comwrote: On Fri, Jul 10, 2009 at 3:03 PM, kranthi kranthi...@gmail.com wrote: because 2,3,4 tables have one to many corespondence. (at least 4 table does) Every heard about SQL joins? I was just purposing a reading about SQL joins and primary keys :) -- Zareef Ahmed :: A PHP Developer in India ( Delhi ) Homepage :: http://www.zareef.net -- Zareef Ahmed :: A PHP Developer in India ( Delhi ) Homepage :: http://www.zareef.net