Problem with MySQL query

Question

This time my setup looks like this: one table with galleries names

CREATE TABLE GalleriesName (
    gallery_id
    , gallery_name
)

and another table with galleries photos

CREATE TABLE GalleriesPhotos (
    photo_id
    , photo_gallery_id
    , photo_name
)

What I need is to get all the galleries with one random picture for each gallery.

Is it possible to do this with a single query?

holms · Accepted Answer · 2010-05-13 18:04:06Z

3

Is it possible to do this with a single query?

Yes it possible. you need to learn to make SUBSELECTS with mysql. Just select a gallery then subselect a random image [ with rand() ] with that gallery ID =)

http://www.fluffycat.com/SQL/Subselect/

answered May 13, 2010 at 18:04

holms

9,67017 gold badges69 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sarfraz · Accepted Answer · 2010-05-13 17:59:52Z

1

It depends how you have setup your tables in terms of relationship of primary key and foreign key. As for random rows, you need to append order by rand() to your query.

answered May 13, 2010 at 17:59

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Collectives™ on Stack Overflow

Problem with MySQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related