Ryan S wrote:
> Hey,
> Am not really used to using the JOIN in SQL so am a bit confused as to what
> kind of data I need to enter into this table:
>
> image_category_mapping table:
> - image_id
> - category_id
It comes down to database normalization
(http://en.wikipedia.org/wiki/Database_normali
Hey,
Am not really used to using the JOIN in SQL so am a bit confused as to what
kind of data I need to enter into this table:
image_category_mapping table:
- image_id
- category_id
for all of this to work... mind explaining a bit?
Thanks!
Ryan
_
On May 1, 2008, at 843AM, Richard Heyes wrote:
it's the most flexible and fastest to query.
Mmm, that's debateable. Not knowing the ins and outs of MySQL I'd
hazard a guess that reading an extra 255 bytes from the table file
might be faster in some circumstances than opening two extra tab
Hey!
Thanks for replying guys!
> 1. Fully normalised, where you have three tables - one for your
> "articles", one for your categories and a link table.
This is the route that I would suggest, it's the most flexible and
fastest to query.
Anyone happen to have a little PHP code as an
it's the most flexible and
fastest to query.
Mmm, that's debateable. Not knowing the ins and outs of MySQL I'd hazard
a guess that reading an extra 255 bytes from the table file might be
faster in some circumstances than opening two extra table files. And I
don't see why it's more flexible...
On May 1, 2008, at 743AM, Richard Heyes wrote:
Is this how its done or am I barking up the wrong tree?
You have multiple options:
1. Fully normalised, where you have three tables - one for your
"articles", one for your categories and a link table.
This is the route that I would suggest, i
Is this how its done or am I barking up the wrong tree?
You have multiple options:
1. Fully normalised, where you have three tables - one for your
"articles", one for your categories and a link table.
2. A "SET" MySQL datatype which will allow upto 32 predefined
categories.
3. A simple CH
On Thu, May 1, 2008 at 9:23 AM, Ryan S <[EMAIL PROTECTED]> wrote:
> Hey!
>
> Heres what i have to do, upload pics and each pic can be a part of x
> number of categores
>
> for example:
> A picture of a rose can be for birthday, as well as anniversary, or miss
> you, or love etc
> exactly the same
8 matches
Mail list logo
