Results 1 to 5 of 5

Thread: silly question

Threaded View

  1. 01-28-2005, 07:47 AM #1
    babel
    babel is offline Registered User
    Join Date
    Jan 2005
    Location
    swansea, wales
    Posts
    2

    silly question

    hi

    I'm currently designing a searchable artist gallery and have a problem with my SQL querying.

    I have the artworks entered in the database as unique entries and have entered the artists forename and surname in separate columns so that they can be seached for by the first letter of their surname.

    The problem is that when a user searches for an artist the results return as many results as there are artworks, rather than artists, in other words if harry potter has 20 pots he appears 20 times.

    Please can anyone advise me how to ammend my query so that he appears only once!
    Last edited by babel; 01-28-2005 at 07:53 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules