Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- MySQL query in products system
July 12, 2005, 9:30 am
rate this thread
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:
Products looks like:
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:
series.name - products.name - products.id
I hope this is enough information.
Re: MySQL query in products system
You pretty much defined the query yourself already...
select s.name, p.name, p.id
from series s, products p
where s.active = 1 and s.kind = 543 and s.id = p.series_id
order by s.name, p.name
Remove/change the order by as required.
(Remove REMOVE for email address)
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum