Inserting and Selecting..

[ofSHIZ]

Ok.. I'm having this weird problem..
I am wanting to make a add news script and I think It worked..
now it wont insert anything into the database..
Insert Script

<?php
session_start()

?>
<?php
$message = $_POST['message'];
$topic = $_POST['topic'];

$db = mysql_connect("localhost","") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!"); 
  mysql_select_db("news",$db);

$sql = "INSERT INTO news (author , message , topic , date , id) VALUES ('$username', '$message', '$topic', CURDATE( ) )";
$result =  mysql_query($sql);

echo "Thanks for posting!<br>
click <a href=index.php> to continue to the home page.</a>";
?>

That won't insert anything into the database.. not even a blank row.. and I know that there is a database named news.news

I added 2 scripts manually to the database.. and it only shows one.. I would like to show all of them ordered by date DESC..

$db = mysql_connect("localhost","") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!"); 
mysql_select_db("news", $db);
$sql = "SELECT message, topic, id, author, date FROM news ORDER BY date DESC"; 
$result =  mysql_query($sql) 
    OR die(mysql_error()); 
    $row = mysql_fetch_array($result); 

$row['message'] = str_replace( ":)", "<img src=\"smilies/happy.gif\">", $row['message']);
$row['message'] = str_replace( ":-)", "<img src=\"smilies/happy.gif\">", $row['message']);

$row['message'] = str_replace( ":(", "<img src=\"smilies/sad.gif\">", $row['message']);
$row['message'] = str_replace( ":-(", "<img src=\"smilies/sad.gif\">", $row['message']);

$row['message'] = str_replace( ":O", "<img src=\"smilies/shocked.gif\">", $row['message']);
$row['message'] = str_replace( ":-O", "<img src=\"smilies/shocked.gif\">", $row['message']);

$row['message'] = str_replace( ":D", "<img src=\"smilies/biggrin.gif\">", $row['message']);
$row['message'] = str_replace( ":-D", "<img src=\"smilies/biggrin.gif\">", $row['message']);

$row['message'] = str_replace( ";)", "<img src=\"smilies/wink.gif\">", $row['message']);
$row['message'] = str_replace( ";-)", "<img src=\"smilies/wink.gif\">", $row['message']);

$row['message'] = str_replace( ":P", "<img src=\"smilies/tongue.gif\">", $row['message']);
$row['message'] = str_replace( ":-P", "<img src=\"smilies/tongue.gif\">", $row['message']);

$row['message'] = str_replace( ":bowling:", "<img src=\"smilies/bowl.gif\">", $row['message']);
$row['message'] = str_replace( ":mad:", "<img src=\"smilies/mad.gif\">", $row['message']);
$row['message'] = str_replace( ":dizzy:", "<img src=\"smilies/dizzy.gif\">", $row['message']);
$row['message'] = str_replace( ":nono:", "<img src=\"smilies/nono.gif\">", $row['message']);
$row['message'] = str_replace( ":eyepatch:", "<img src=\"smilies/pirate.gif\">", $row['message']);
$row['message'] = str_replace( ":sick:", "<img src=\"smilies/sick.gif\">", $row['message']);
$row['message'] = str_replace( ":cry:", "<img src=\"smilies/cry.gif\">", $row['message']);
$row['message'] = str_replace( ":uhh:", "<img src=\"smilies/uhh.gif\">", $row['message']);
$row['message'] = str_replace( ":wacko:", "<img src=\"smilies/wacko.gif\">", $row['message']);
$row['message'] = stripslashes($row['message']);
    echo ".::" . $row['topic'] . "::.<br> <i>Posted by: " 
        . $row['author'] . " on " . $row['date'] . "</i><br>" 
        . $row['message']; 
		echo "<br><br><br>";

[programmer79]

 $sql = "INSERT INTO news (author , message , topic , date , id) VALUES ('$username', '$message', '$topic', CURDATE( ) )";

you are inserting 4 values into 5 fields, so either add another value or remove the id field. You should also place a or die message after the query to help with troubleshooting.

[ofSHIZ]

Ok.. it still displays only one thing from the database.. any other suggestions?

[ofSHIZ]

Nevermind.. I Fixed it.