More than 50 entries!!!

------=_NextPart_000_0004_01CA0114.70D7E050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

=20

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?

=20

And how do I do a search with this 4 tables strucutre?

Thanks a lot!

=20

+ =
_
// Emiliano Boragina _
// Dise=F1o & Comunicaci=F3n //////////////////
+ =
_
// emiliano.boragina@gmail.com /
// 15 40 58 60 02 ///////////////////////////
+ =
_

=20


------=_NextPart_000_0004_01CA0114.70D7E050--

Re: 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=A0mysql_insert_id() to
get the product id.

thereafter use the unique product id to=A0refer=A0to the product (in the
database tables)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: More than 50 entries!!!

--00504502c3ccb5a571046e567ad0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 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

--00504502c3ccb5a571046e567ad0--

Re: More than 50 entries!!!

--000e0cd2421cbc7337046e56ac4e
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

because 2,3,4 tables have one to many corespondence. (at least 4 table does)

--000e0cd2421cbc7337046e56ac4e--

Re: More than 50 entries!!!

--0015174be276963a31046e631117
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--0015174be276963a31046e631117--

Re: More than 50 entries!!!

--0015174bf1dc82bcfd046e63164a
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 :)






>
> --
> 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

--0015174bf1dc82bcfd046e63164a--