Re: working on my new blog and...

[Draconis]

Lego Boy wrote:

> so, I would like to know how to do a query when
> someone is logged in for to return a blog and have
> a link for each permission that user has to that
> post. eg hide a post if the logged in user is an
> admin and the person who posted is not an admin
> unles it is their own post. or have a delete and
> edit button if the user who is logged in is an
> admin or it is their own post. Etc...

Almost all of that is going to depend on your scripting/programming language and is so far beyond the scope of discussion that we're going to have to wave an enormous flag so you can find your way back.

The above is the basis for some interesting logic, but the where clauses will totally depend on you doing authentication _before_ grabbing the various details. Not only that, but I don't think your table design will work as planned. You could imply editing for the 'owner' of the post, and apply an admin bit (global admin rights) to the users table which would simplify the lot. I'm mindful that this could oversimplify, but complexity is your enemy (where there is insufficient abstraction).

Draconis