Hi there
I have a products site with a mysql backend.
I have two tables:
1 with series,
1 with products belonging to certain series.
Series looks like:
- id
- kind
- active
- name
Products looks like:
- id
- series_id
- name
Since i'm kind of a newbie, i can't figure out the
following:
I need the query to get all product-information on products that are
in a series where 'series.Active = 1' and 'series.kind = 543' (e.g.
543)
Products have to be limited (e.g. 20)
output sort of has to be:
series.name - products.name - products.id
I hope this is enough information.
Thanks!
Frizzle.