MySQL query in products system

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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
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.
Products have to be limited (e.g. 20)
output sort of has to be: - -

I hope this is enough information.



Re: MySQL query in products system

frizzle ( decided we needed to hear...
Quoted text here. Click to load it

You pretty much defined the query yourself already...

from series s, products p
where = 1 and s.kind = 543 and = p.series_id
order by,
limit 20

Remove/change the order by as required.
(Remove REMOVE for email address)

Re: MySQL query in products system

Thanks a bunch!!!!

Greetings Frizzle!
(lots to learn :) )

Site Timeline