Need Help With Public/Private PHP Button

[saadlive]

Hi there,

I am making a blog and it works perfect except I want to make it so when you log in you can see the private posts and the public can see the public posts.

I made a public button on the blog submission form. I also made it in my SQL database for a public yes/no line.

Now what should I put in my code to make it so it only shows public ones if you arent logged in and if you are logged in then you can see the private posts.


Help? lol

[jeremywesselman]

[code]<?php
if($IsLoggedIn)
{
     //if client is logged in, show all posts
     $sql = "SELECT * FROM posts";
}
else
{
     //if client is not at logged in, show only public posts
     $sql = "SELECT * FROM posts WHERE public = 'yes'";
}
?>[/code]

Where $IsLoggedIn is a variable that that you set after you log in.

[!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]Jeremy[!--colorc--][/span][!--/colorc--]

[poirot]

That's not all, you will have to modify the script that INSERTs the entry; and also create a public/private button.

[jeremywesselman]

An alternate would be to make a public/private button and write it in the script where you manage your blog posts. This way, you could change the type of post back and forth.

[!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--]Jeremy[!--colorc--][/span][!--/colorc--]