Building a "favorite this" system and totally stuck

[eluser]gullah[/eluser]
ok so you are going to be doing a foreach loop to print out the blogs more than likely

This is how I would do it and I don't think it would be a problem with resources unless the users are voting on many many blogs.

or you could work on your query to see if you can single it down more.

so...
foreach(blogs as blog)
{
foreach(votes as vote)
{
$voted = 0;
if(vote->blog_id == blog->id)
{
$voted = 1;
}
}
$if($voted == 0)
{
display vote link
}
display blog
}