Posting News

brbsta

Im a little bit new at this and jsut have a few questions. Im making a system for a school website where every sport and club can go edit and add and delete there own news that is on there page. Instead of having like 20 files for sperate for all of the add edits and deletes for EVERY sport or club i cant to put it on one page. So right now for the post to database page i Have

<?php
include "secure.php";
include "config.php";
//change $nlev to the level needed to access page
if ($lev >= $nlev) {
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "INSERT INTO news (title, news, author, date, aff)
VALUES('".$POST['title']."','".$POST['news']."','".$_POST['author']."', now(), 'yes')";
mysql_query($query);
echo "News item entered.";
mysql_close($db);
} else {
print "Sorry, you do not have the required access levels";
}
?>

So what I want to say if lev=6 aff=soccer. When when i go to the view file it will say

<?php
include "admin/config.php";

$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
/ We have now connected, unless you got an error message /
/ Lets extract the data (news) from the database /
$query = "SELECT title, news, author, date FROM news WHERE aff='soccer' ORDER BY id DESC LIMIT 10";
$result = mysql_query($query);
/ Here we fetch the result as an array /
while($r=mysql_fetch_array($result))
{

/ This bit sets our data from each row as variables, to make it easier to display /
$title=$r["title"];
$tit=$r["news"];
$author=$r["author"];
$date=$r["date"];
$trat=$r["aff"];
$news=nl2br($tit);
/ Now lets display the news /

Can i Put like if ($lev=6) $aff=soccer and just make a whole list of that for each level.

Thank for any help.

thorpe

nope....no idea what your after.

have you got a login system?

brbsta

Yea I already have the script done for the login for the users, this is the news part of the system. Where IM gonna have like 20 differnt news sections for differnt people will have there own news.

chucklarge

so what i would do is setup an admin user for each group. in your db users table, you could have a field for group. so when a user logs in and goes to your news creation page, you already know what group they belong to.

when they add a new news item, put that group in the db field on the same row as the news message.

on your individual group page, just read from the news table and only print the articles from that group.

you would only have one news creation page and one database table hold all the news articles.