Topic awaiting preservation: select only one register from different fields (Page 1 of 1)

Hello, I've been thinking about this but i don't find a way to do it
I want to select only one register from different fields.

Humm, hard to explain:

I'm making a photogallery, and the pics are ordered by cathegory, in the main page I want to show one pic from each cathegory.

I have the database like this:

Table name: table_img:
Fields: big_image, thumbnail, description, category

Table name: table_cat
Fileds: Cat_name, Description

How can I select one pic from each cathegory?

very nice question!

I don't know how to do that or if it is even possible!

but you know that you can easily do it programmatically (in PHP, ASP, whatever SSS lang.), right?

Nop, I dunno!!!!

Use "GROUP BY" SQL statement in your SELECT query...
http://www.mysql.com/doc/en/SELECT.html

Okay, Wakkos, mr.Max gave us a hint:

quote:

---

Table name: table_img:
Fields: big_image, thumbnail, description, category

Table name: table_cat
Fileds: Cat_name, Description

---

my query goes like:

select 

  table_img.thumbnail, table_img.description, 

  table_cat.cat_name as CategoryName

where

  table_img.category = table_cat.cat_name

group by 

  table_cat.cat_name

you will have as many rows as you've got categories.

good luck.

I've been working on this, I got to this, but it prints 5 registers and it does not matter the cathegory!
I would like to be one from cathegory and I have played with this a lot! but, Jheez.....

Here's the code, if any have a little of time to take a look at it, thanks a lot!!!

$query_select = "select wakk_gallery.imagen, wakk_gallery_cat.categoria FROM wakk_gallery,wakk_gallery_cat WHERE wakk_gallery.categoria = wakk_gallery_cat.categoria LIMIT 5";

Wakkos, you didn't use GROUP BY SQL statement like I suggested in my post from above (and that's why your query doesn't work correctly)...

Done!!

I made it with the Group by, but when i was selecting the table to group by, it was not the table, it must be a column of a table..

I got it now:

(very close to lallous code)

$query_select = "select wakk_gallery.imagen, wakk_gallery_cat.categoria FROM wakk_gallery,wakk_gallery_cat WHERE wakk_gallery.categoria = wakk_gallery_cat.categoria group by wakk_gallery_cat.categoria";

Thank you both, guys!