Jump to content

Getting SQL records to only show up once if there are multiples. Possible? DW MX


Recommended Posts

In Dreamweaver MX.

I am creating a link index of different written works. I want the different viewing options to be flexible, such as browsing through written works based on the title, based on the author, and whatnot.

I would like to create an author page, and I think I have most of it. I downloaded the Navigation suite so that I can use letters to help navigate.

The problem is, a lot of the written works are written by the same authors. One author's name will show up several times in the database. How do I make it so that it only shows up once when the results display?

If I can avoid coding, I would like to, because coding seriously baffles me. I am still very much a layman with PHP.

If I can get it to only show up once, I think my problems are solved. I know how to create detail pages and such. It's just that tricky problem of making sure that my page isn't filled up with the same author for one particular letter.
Link to comment
Share on other sites

Urk, nevermind. It seems that once I introduce URL parameters into the query, it doesn't seem to want to work. I'm not sure why that is. The query works fine with the parameter without the DISTINCT tag on it, but once I add it, nothing shows up in the query. I don't even get an error message.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.