Member Avatar for eakinpeter

Hi all

Problem is I want to return unique results based on 2 fields:

I have a table tags_photos which is a join table and has 2 fields: tagId and PhotoId.

I want to create a page which has a list of all tags and a thumbnail against each tag. However I only want to show each tag once and I want a diff picture for each tag if possible(so the same pic isn't repeated).

Any help would be appreciated
Peter

  • 2 Contributors
  • 1 Reply
  • 75 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by guru12
Member Avatar for guru12

Hi,

First you select the values from the database using "Select query", after select the values, you use the following function for your results
array_unique($value)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.