Re: [PHP-DB] More than 50 entries!!!

2009-07-10 Thread Zareef Ahmed
On Sat, Jul 11, 2009 at 5:51 AM, Zareef Ahmed wrote: > > > On Fri, Jul 10, 2009 at 3:03 PM, kranthi 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 :)

Re: [PHP-DB] More than 50 entries!!!

2009-07-10 Thread Zareef Ahmed
On Fri, Jul 10, 2009 at 3:03 PM, kranthi 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!!!

2009-07-10 Thread kranthi
because 2,3,4 tables have one to many corespondence. (at least 4 table does)

Re: [PHP-DB] More than 50 entries!!!

2009-07-10 Thread WenDong Zhang
why separate the products to 4 table? On Fri, Jul 10, 2009 at 4:54 PM, kranthi 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 r

Re: [PHP-DB] More than 50 entries!!!

2009-07-10 Thread kranthi
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/) T

[PHP-DB] More than 50 entries!!!

2009-07-10 Thread Emiliano Boragina
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 se