MySQL LIMIT or GROUP?

2 posts by 2 authors in: Forums > CMS Builder
Last Post: June 9, 2009 (RSS)

Archived
Reply
Reply

By ncasares - June 8, 2009

I have a table that looks like:

- Manufacturer
- Name
- Price

I'd like to display results that are limited to 3 rows per manufacturer, but I'm struggling with the query. Does anyone know how to do this? I'm assuming I would need to invoke GROUP then somehow LIMIT the results, but I'm lost on the syntax.

Thanks.

Re: [ncasares] MySQL LIMIT or GROUP?

Archived
Reply
Reply

By ross - June 9, 2009

Hi there.

Thanks for posting!

I don't quite understand what you are trying to setup here. Based on the table structure you listed, there would only be one manufacture per row anyway. I might be missing something though :).

Do you have a mock up of what this all needs to look like? That's actually the best place to start. Post a link to that with some more detail and we'll go from there.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/