Posted by Dejan on 04/10/06 01:38

My table structure i's like that.
No one cann't have same image name. My data in the table really look's like
this...

id Name Surname Image1
Image2
mmijic27542 Mirjana Mijic mmijic27542_776_mijic1_v.jpg
mmijic27542_2_778_mijic3_v.jpg

and manny more coloumns in this row.
Id, and images names are generated random during insert, depending on
peoples name, surname, and random function.
So no one cann't have the same id, or images names.

Dejan



strawberry <zac.carey@gmail.com> wrote in message
news:1144500048.823058.179400@z34g2000cwc.googlegroups.com...
> Also, is that really the structure of your table!?!
>
> I'd consider a structure like this instead...
>
> users
>
> user_id f_name l_name
> 1 John Lennon
> 2 Paul McCartney
> 3 George Harrison
> 4 Ringo Starr
>
> images
>
> image_id image_name
> 1 yoko.jpg
> 2 julia.jpg
> 3 linda.jpg
> 4 heather.jpg
> 5 patti.jpg
> 6 olivia.jpg
> 7 barbara.jpg
>
> user_images
>
> user_id image_id
> 1 1
> 1 2
> 2 3
> 2 4
> 3 5
> 3 6
> 4 7
>

[Back to original message]