Hi All
Stuck on a mysql query.
I will explain what it needs to do.
The query needs to select all entries from a table (portfolio_entries) where column 'type' = 'roofgardens', it needs to get a picture for each of those entries from a table called portfolio_images, where the colunm 'portfolio_id' is the same as that from the previous part of the query. It then needs to only bring back pictures where the column 'pic_type' = 'small'... to further complicate matters there are 4 small pictures for each portfolio entry.. I only need one
Any help is appreciated, because I am well lost
aaron
Stuck on a mysql query.
I will explain what it needs to do.
The query needs to select all entries from a table (portfolio_entries) where column 'type' = 'roofgardens', it needs to get a picture for each of those entries from a table called portfolio_images, where the colunm 'portfolio_id' is the same as that from the previous part of the query. It then needs to only bring back pictures where the column 'pic_type' = 'small'... to further complicate matters there are 4 small pictures for each portfolio entry.. I only need one
Any help is appreciated, because I am well lost
aaron