PHP/MySQL News with Comments by Matt Wade (HELP NEEDED)

Original - php Code <div id="shortpage"> <h2>Add News</h2> <p><b>Add News Item:</b> </p> <div id="form"> <form method="post" action="?page=add_news_post"> <input name="title" type="text" value="Subject" size="30" /><br /> <textarea name="newstext" cols="30" rows="10">News</textarea> <input type="submit" name="submit" value="Submit"> </form> </div>

 
<div id="shortpage">
<h2>Add News</h2>
<p><b>Add News Item:</b> </p>
<div id="form">
<form method="post" action="?page=add_news_post">
  <input name="title" type="text" value="Subject" size="30" /><br />
    <textarea name="newstext" cols="30" rows="10">News</textarea>
  <input type="submit" name="submit" value="Submit">
</form>
</div> 

Original - php Code <? //initilize PHP if($submit) //If submit is hit { mysql_connect("localhost","db_user","db_password"); //then connect as user mysql_select_db("db_mydb"); //select which database you want to edit $result=MYSQL_QUERY("INSERT INTO news (id,postdate,title,newstext)". "VALUES ('NULL', '$postdate', '$title', '$newstext')"); //Insert the values into the correct database print "<p>This file has the Database."; //Get a conformation that it has been uploaded } ?>

 
<? //initilize PHP
if($submit) //If submit is hit
{
    mysql_connect("localhost","db_user","db_password"); //then connect as user
    mysql_select_db("db_mydb"); //select which database you want to edit
    $result=MYSQL_QUERY("INSERT INTO news (id,postdate,title,newstext)".
    "VALUES ('NULL', '$postdate', '$title', '$newstext')"); 
    
    //Insert the values into the correct database
    print "<p>This file has the Database."; //Get a conformation that it has been uploaded
}
?> 

Original - php Code <?php $db = mysql_connect("localhost", "jayhills_pixel","AWMRmm"); mysql_select_db("jayhills_pixelated",$db); //for new PHP $title=$_POST[title]; $newstext=$_POST[newstext]; // $sql = "INSERT INTO news (id, postdate, title, newstext) VALUES ('','','$title','$newstext')"; $result = mysql_query($sql); echo "Thank you! Information entered.n"; ?>

 
<?php
$db = mysql_connect("localhost", "jayhills_pixel","AWMRmm");
mysql_select_db("jayhills_pixelated",$db);
 
//for new PHP
$title=$_POST[title];
$newstext=$_POST[newstext];
//
 
$sql = "INSERT INTO news (id, postdate, title, newstext) 
VALUES ('','','$title','$newstext')";
$result = mysql_query($sql);
echo "Thank you! Information entered.n";
?> 

Original - php Code $query = "SELECT id,title,newstext," . "DATE_FORMAT(postdate, '%l, %D %M') as date " . "FROM news ORDER BY postdate DESC LIMIT $max_items";

 
        $query = "SELECT id,title,newstext," . 
                 "DATE_FORMAT(postdate, '%l, %D %M') as date " . 
                 "FROM news ORDER BY postdate DESC LIMIT $max_items";