Re: working on my new blog and...

[Lego Boy]

here are the tables:

users:
id int(3) unsigned
user_name varchar(20)
password varchar(30)

blogs:
id int(3) unsigned
title varchar(100)
hidden int(1) unsigned

posts:
id int(5) unsigned
blog_id(3) unsigned
user_id(3) unsigned
posttime datetime
post text
hidden int(1) unsigned

permissions:
id int(5) unsigned
blog_id(3) unsigned
user_id(3) unsigned
permission set('read', 'write', 'admin');

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...