cberube09

Never mind, I finally got it. Thanks for the tip.

Thanks, that helps a lot. Didn't know that existed, I was trying to do it with some sort of PHP script. Now, I can get the latest articles that were commented on by using this code $query='SELECT DISTINCT title FROM comments ORDER BY commentid DESC LIMIT 0,5'; However, I also want to select the category that each article is in, and this category is NOT distinct. It doesn't seem like I can blend the two into one statement, so how to I find the correct category that matches up to each of the articles?

Seems to be coming along pretty good. For the new site, my suggestions so far would be to remove the video unless it is absolutely necessary, and move away from the bright red text on the white background. It isn't very readable and just doesn't seem to match very well with the overall color scheme of the site. Just some personal opinions, but I hope to see how it evolves. Good luck with it.

Hi, I am trying to select recently commented articles out of a database. I want to display the last 5 commented articles, so I originally just set a LIMIT to the mysql query to 5. However, if the title of the article is the same as one already being shown in the newest 5, I do not want it to show up again. To clarify, I want the 5 most recently commented UNIQUE articles to show up. So if Jim and Sue both commented on an article called Dogs, than that article would show up once in the top 5 list, and 4 other articles would show up as well. How can I do this?

Alright, thanks for the feedback! I'm glad you guys like the new look better. I will continue work on it tommorow.

Thanks for the link. I actually just completed a new layout before seeing that, but are there any opinions?

Now that's embarrassing! I shouldn't be editing the website on the live server! Sorry! Its all set now though.

Thanks, that's good to know, because I could not get it to work.

I have certainly taken your comments into consideration, thanks. I have moved the home link to the first section in the unordered list, changed the top tabs, and validated the entire site. I feel that they layout works for what I'm trying to do, however I am sure up for any further suggestions, I just didn't think that the container div style is what I'm looking for. I added some padding, but to the text and not the container boxes. I left the search at the top of the navigation box because I feel it is important and needs to be accessible right away without scrolling. I have tried to think of a color other than the green, but nothing is seeming to work for me. Are there any further opinions? Thanks!

Something like this... index.php?content=main&id=Government_Policy&title=Hypocritical_Politicians I want to encode the ampersands because that this is required by W3 specification. Since the ampersand does not mean AND but is an operator in the link, it must be encoded.

Didn't know about the full address, but I'm trying to encode the &s between main and id and between categoryout and title, not the variables i am including

Hmm maybe I shouldn't be getting myself into this right now but if there is a bunch of different checks that you want to run and you use if(something) { $errors[] = "Some error message."; } then wouldn't that only check one condition? You don't want multiple messages for one condition, but different error messages for different conditions, so you would use multiple arrays. Am I thinking about this correctly?

Right, sorry, that what I meant, I just wrote the wrong thing. This is the code with the url unencoded header("Location:index.php?content=main&id=$categoryout&title=$titleout"); When I use anything like & or %26, that is what shows up in the URL when it redirects, not the regular &, so in turn, the page is not found.

Well my arrays do something useful, its just that I don't know what css elements he is using. And I am a bit overtired but I believe that what you wrote doesn't work for some reason or another...not quite sure about that though.

The only problem is that the browser url shows the &26 and not the & so the page is not found.