Not Echoing but Recording

[Apixen]

NEWS SHOW

<?php
include('../includes/config.inc.php');
@mssql_select_db($AccountDB);

$getnews = @mssql_query("SELECT TOP 5* FROM [NEWS_TBL] order by id desc");
while($fetchnews = @mssql_fetch_array($getnews))
{
echo "<b>" .$fetchnews['title'];
echo "</b><br />";
echo $fetchnews['message'];
echo "<br />";
echo "<i><font size='1.5'>Posted on: " .$fetchnews['date'];
echo "  By: ".$fetchnews['postedby'];
echo "</i></font size><br /><br /><br />";
}
?>

NEWS EXECUTE

<?php
 echo "<center>";
 echo "<form method='post'>";
  echo "Message Title: <input type='text' name='title' maxlength='40'><br>";
 echo "Message: <textarea cols='30' rows='8' name='message' maxlength='200' wrap=virtual></textarea><br>";
 echo "<input type='submit' value='Submit' name='submit'><br>";


if(isset($_POST['submit'])) {

include('../includes/config.inc.php');
if(@$_SESSION['Account2'])
{
@mssql_select_db($AccountDB);
$title = $_POST['title'];
$message = $_POST['message'];
$postedby = $_SESSION['Account2'];
$v_date = date("l d F H:i:s"); 


$insert = @mssql_query("INSERT INTO [NEWS_TBL] (title, message, date, postedby) VALUES ('$title', '$message', '{$v_date}', '{$postedby}')");
if($insert) {
echo 'Your news thread has been posted successfully!';
} else
{
echo 'Error inputting news.';
}
}
}
?>

Probably someone is gonna say to indent your code, but I just don't indent, sorry.

Anyway, I run a script in which when you input text into a text box, it'll go into the database, as well as your session name.

The problem is that it WILL ALWAYS record the information in MSSQL, but it will never echo it out on the news. Any help?

[bradgrafelman]

Apixen wrote:

but I just don't indent, sorry.

That's fine - many people will simply say to themselves "I just won't read your thread then, sorry" and happily move on. 😉

As for your problem.. first of all, how do you know that it's recording the information in MSSQL? Have you manually browsed the table and found that the data was properly being inserted?

Second... why do you use the '@' error suppressor? In my opinion, this should never be used, since a) it prevents PHP from displaying valuable error information when debugging a problem, and b) it prevents PHP from logging valuable error information when deploying an application to your production server. In other words, the first thing you should do is remove any and all instances of the '@' error suppressor from your code.

Also... does the first script loop through rows and print out blank lines, or does it never echo anything at all? If it's the latter, that suggests that your query was malformed and/or mssql_query() (and/or mssql_fetch_array()) are generating error messages.

[Apixen]

I'll check it out, Thanks
Check back on this post, cause I'll edit this one. ;>

[Apixen]

My problem is being fixed, Apparently, I still cant edit posts ;<

thanks for the reply. I'll be sure to NOT use the @ sign when testing ;>