Re: Help needed on a small SELECT/JOIN statement

[Chris Farrugia]

Thanks for the fast reply! I'll give that query a shot. A few follow up questions:

1. The id used in the views table is the same as the article table. So if someone clicks on article #4, then an entry is made to the views table with their ip, 4 as the id, and type=article. That's my newbie way of tracking unique views. You mentioned my naming convention so I'd love to hear any improvements that I should make. Criticism will definitely help me learn.

2. If using PHP to output this query, in my while statement everything is an array of $query_data. Could I just refer to the count then as $query_data[num_views]?

Thanks again!