News script?

[willow]

Can anyone recommend a simple news script? Something i can skin to merge with my sites and obviously something stable so i dont get my account suspended

[meltingcube]

Here is a simple one:

PHP Code:

$_SERVER['c_mysql_host'] = "localhost";
$_SERVER['c_mysql_user'] = "db_user";
$_SERVER['c_mysql_password'] = "passwd";
$_SERVER['c_mysql_database'] = "db_name";

$connection = mysql_connect($_SERVER['c_mysql_host'],$_SERVER['c_mysql_user'],$_SERVER['c_mysql_password'])
    or die ("Couldn't connect to server.");

$db = mysql_select_db($_SERVER['c_mysql_database'], $connection)
    or die ("Couldn't select database.");

$sql = "SELECT id,title,date,body FROM news ORDER BY id DESC";
    $r = mysql_query($sql)
            or die("Couldn't execute query. ".mysql_error());
        
    while ( $row = mysql_fetch_assoc($r) ) {
        echo "<div id=\"news_{$row[id]}\">{$row[title]}<br />{$row[date]}<br />{$row[body]}</div><br /><br />";
} 


It's a little rough but i'm sure you get the gist of it. All you have to do is insert this into a page, create the database, edit the login information, and add the items into the database. Now if you want the option to add them via the web by logging in on your site that will take a bit more. But this should be fine for just displaying the news.

If needed just PM me and I can help you on a more personal level.

[willow]

Thats really kind of you Dan but its way out of my league. I dont know the first thing about php and messing around with databases would be like pulling my hair out
I really need something with an admin interface, WYSIWYG etc.

I really appreciate your offer though

[meltingcube]

Haha, no problem. Really PHP is a very easy a good programming language to learn (of course you ASP guys will object ). Here is one I found using a quick Google search. It should be fine for what you want.

http://www.gentlesource.com/news-script/

[willow]

I dont know whether to kiss you or kick you Dan

Ive spend the last couple of hours on Hotscrips and couldnt find anything that looked good and you pop on to Google and find this beauty!

Looks very good indeed and i owe you a beer but if anyone else can recommend anything they use its would be appreciated too

[meltingcube]

Haha, no problem. I remember when I was first starting out several years ago no one would help me other forums so I had to learn everything my self, which was hard. So I make sure if I can help, I do.