Re: [PHP] Help wtih a query?

Skip Evans wrote:
Hey all,

I have the following query:

$sql="SELECT count(*) AS count,votes.storyID,stories.title,stories.storyID as sID,stories.approved, stories.story,stories.userID, fname, lname
FROM `bsp_story_votes` as votes, bsp_story_stories AS stories, users AS usr
WHERE votes.storyID=stories.storyID AND stories.userID=usr.id AND stories.contestID=$contestID
GROUP BY votes.storyID
ORDER BY stories.approved,count DESC, sID ASC LIMIT $b_recno,$recs";

How would this need to be changed so that it would return rows for the members of the bsp_story_stories table that do not have records in the bsp_story_votes table?

Is that what the left/right joins do???

Look up 'left outer join'
I believe that is what you are looking for.
-B
Thanks!
Skip

.