Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

?advance? sql query


emiliano

Recommended Posts

hi everyone.. i have a problem with a sql query.. after searching and trying to understand what the manual says i'm trying to solve this problem with your help!

 

i couldn't found in the sql manual (my english is pretty limited) a way to select "x" rows but i need that every record had a diferent category from each other...

my table is something like this

 

ID | TITLE | CATEGORY

1 Fly again 1

2 Shut up 2

3 Bye 3

4 Hello! 4

5 Mama mo 3

6 Payaso 2

 

I need to let say show 4 records.. the lastest one of each category.. but in only one result page.. i can't figure out how to do this with only one query, it'd be easy doing 4 queries, but i like challenges.. (althoug i'm losing this one at the moment)..

 

thanks in advance

emiliano

patagonia, argentina

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...