Modified News w/PHP and MySQL problem..

Original - php Code <?PHP /* user config variables */ $max_items = 8; /* max number of news items to show */ /* make database connection */ $db = mysql_connect ('localhost','xxxx','xxxx'); mysql_select_db ('news',$db); function displayNews($all = 0) { /* bring in two variables * $db is our database connection * $max_items is the maximum number * of news items we want to display */ global $db, $max_items; /* query for news items */ if ($all == 0) { /* this query is for up to $max_items */ $query = "SELECT id,poster,title," . "DATE_FORMAT(postdate, '%m-%d-%Y') as date " . "FROM newsdata ORDER BY postdate DESC LIMIT $max_items"; } else { /* this query will get all news */ $query = "SELECT id,poster,title,newstext," . "DATE_FORMAT(postdate, '%m-%d-%Y') as date " . "FROM newsdata ORDER BY postdate DESC"; } $result = mysql_query ($query); while ($row = mysql_fetch_assoc ($result)) { /* display news in a simple table */ /* place table row data in * easier to use variables. * Here we also make sure no * HTML tags, other than the * ones we want are displayed */ $date = $row['date']; $title = htmlentities ($row['title']); $poster = $row['poster']; $id = $row['id']; /* display the data */ echo "<TR align="center"><TD id="tabblue"><a href="{$_SERVER['PHP_SELF']}" . "?action=show&id=$id">$title</a> posted by $poster, on $date</TD></tr>n"; } } function displayOneItem($id) { global $db; /* query for item */ $query = "SELECT id,poster,title,newstext," . "DATE_FORMAT(postdate, '%m-%d-%Y') as date " . "FROM newsdata " . "WHERE id=$id " . "ORDER BY postdate DESC"; $result = mysql_query ($query); /* if we get no results back, error out */ if (mysql_num_rows ($result) == 0) { echo "Invalid news ID number.n"; return; } $row = mysql_fetch_array($result); /* easier to read variables and * striping out tags */ $date = $row['date']; $poster = $row['poster']; $title = htmlentities ($row['title']); $news = nl2br (strip_tags ($row['newstext'], '<a><b><i><u>')); /* display the data */ echo "<TR align="center"><TD id="tabblue"><b>$title</b> posted by $poster, on $date</TD></tr>n"; echo "<tr align="center"><TD id="tabblue">$news</TD></TR>n"; } /* this is where the script decides what do do */ echo "<CENTER>n"; switch($_GET['action']) { case 'show': displayOneItem($_GET['id']); break; case 'all': displayNews(1); break; default: displayNews(); } echo "</CENTER>n"; echo "</table>"; echo "<br><a href="{$_SERVER['PHP_SELF']}" . "?action=all">View all news</a>n"; ?>

 
<?PHP
/* user config variables */
$max_items = 8; /* max number of news items to show */
 
/* make database connection */
$db = mysql_connect ('localhost','xxxx','xxxx');
mysql_select_db ('news',$db);
 
function displayNews($all = 0) {
    /* bring in two variables
     * $db is our database connection
     * $max_items is the maximum number
     * of news items we want to display */
    global $db, $max_items;
    
    /* query for news items */
    if ($all == 0) {
        /* this query is for up to $max_items */
        $query = "SELECT id,poster,title," . 
                 "DATE_FORMAT(postdate, '%m-%d-%Y') as date " . 
                 "FROM newsdata ORDER BY postdate DESC LIMIT $max_items";
    } else {
        /* this query will get all news */
        $query = "SELECT id,poster,title,newstext," . 
                 "DATE_FORMAT(postdate, '%m-%d-%Y') as date " .
                 "FROM newsdata ORDER BY postdate DESC";
    }
    $result = mysql_query ($query);
    while ($row = mysql_fetch_assoc ($result)) {
        /* display news in a simple table */
 
 
        /* place table row data in 
         * easier to use variables.
         * Here we also make sure no
         * HTML tags, other than the
         * ones we want are displayed */
        $date = $row['date']; 
        $title = htmlentities ($row['title']);
        $poster = $row['poster']; 
        $id = $row['id'];
        
        /* display the data */
        echo "<TR align="center"><TD id="tabblue"><a href="{$_SERVER['PHP_SELF']}" .
             "?action=show&id=$id">$title</a> posted by $poster, on $date</TD></tr>n";
    }
    
}
 
function displayOneItem($id) {
    global $db;
    
    /* query for item */
        $query = "SELECT id,poster,title,newstext," . 
                 "DATE_FORMAT(postdate, '%m-%d-%Y') as date " .
                 "FROM newsdata " . 
                 "WHERE id=$id " .
                 "ORDER BY postdate DESC";
    $result = mysql_query ($query);
    
    /* if we get no results back, error out */
    if (mysql_num_rows ($result) == 0) {
        echo "Invalid news ID number.n";
        return;
    }
    $row = mysql_fetch_array($result);
    /* easier to read variables and 
     * striping out tags */
    $date = $row['date']; 
    $poster = $row['poster'];       
    $title = htmlentities ($row['title']);
    $news = nl2br (strip_tags ($row['newstext'], '<a><b><i><u>'));
        
    /* display the data */
    echo "<TR align="center"><TD id="tabblue"><b>$title</b> posted by $poster, on $date</TD></tr>n";
    echo "<tr align="center"><TD id="tabblue">$news</TD></TR>n";
}
 
/* this is where the script decides what do do */
 
echo "<CENTER>n";
switch($_GET['action']) {
    
    case 'show':
    displayOneItem($_GET['id']);        
        break;
    case 'all':
        displayNews(1);
        break;
    default:
        displayNews();
 
}
echo "</CENTER>n";
 
echo "</table>";
echo "<br><a href="{$_SERVER['PHP_SELF']}" .
       "?action=all">View all news</a>n";
?>