Code All Of A Sudden Stopped Working

[SChaput]

The below code has been working fine on my server for some time now, however tonight i realized it was not outputting anything. Anyone know why this is the case?
Thanks

<?php
  if ($HTTP_POST_VARS['submit']) {
    mysql_connect("","","");
    mysql_select_db("");
    $entrytext=$HTTP_POST_VARS['entrytext'];
	$entrytime=$HTTP_POST_VARS['entrytime'];
    $query ="INSERT INTO hmrTemp (entrytext,entrytime)";
$query.=" VALUES ($entrytext,$entrytime)";
    $result=mysql_query($query);
	
   $query1 ="SELECT id, entrytext";
   $query1.=" FROM hmrTemp ORDER BY id DESC LIMIT 1";
   $result1=mysql_query($query1);
   while (list($id,$entrytext) = 
    mysql_fetch_row($result1)) {
	?>
<div align="center">Post Successful. If you followed our rules, it will be visible on the main page soon! 
  <p>
  <?php
 echo "<a href='#'>[Click Here To Continue]</a>";
      
      }}
      ?>

[forum_amnesiac]

Just 2 things to suggest about your script

1 $HTTP_POST_VARS is now deprecated and replaced by $_POST, try doing this.

2 Try changing this section

    $query1 ="SELECT id, entrytext";
   $query1.=" FROM hmrTemp ORDER BY id DESC LIMIT 1";
   $result1=mysql_query($query1);
   while (list($id,$entrytext) = 
    mysql_fetch_row($result1)) {
    ?> 

to this

     $query1 ="SELECT *";
   $query1.= ' FROM `hmrTemp` WHERE entrytext="' . $entrytext . '"'
   $result1=mysql_query($query1);
   $num=mysql_num_rows($result1);
    if ($num != 0){
    ?> 

[SChaput]

Still not having any luck.

<?php
  if ($_POST['submit']) {
    mysql_connect("freshsql.com:3306","","");
    mysql_select_db("");
    $entrytext=$_POST['entrytext'];
	$entrytime=$_POST['entrytime'];
    $query ="INSERT INTO hmr entrytext,entrytime VALUES $entrytext, $entrytime";
    $result=mysql_query($query);
	?>
<div align="center">Post Successful. If you followed our rules, it will be visible on the main page soon! 
  <p>
  <?php      
     }
      ?>

Thats the code to add to the database...to GET to that page, i use this form.

<form method="POST" action="addentry.php">
    <table width="143" border="0" align="center" cellpadding="3" cellspacing="3">
    <tr>
      <td width="131"><p align="left">
 text here
        <textarea name="entrytext" cols="45" rows="5" wrap="physical" id="entrytext"></textarea>
          <input type="submit" name="submit" value="Submit">
            
        </td>
    </tr>
  </table>
  </form>

Still no luck adding anything to the database.

[forum_amnesiac]

Where do you get the entrytime variable from?

[SChaput]

I'm sorry i should have taken that out, im not using it anymore.

<?php
  if ($_POST['submit']) {
    mysql_connect("localhost","",");
    mysql_select_db("");
    $entrytext=$_POST['entrytext'];
    $query ="INSERT INTO hmrTemp entrytext";
$query.=" VALUES $entrytext";
    $result=mysql_query($query);
	?>
<div align="center">Post Successful. If you followed our rules, it will be visible on the main page soon! 
  <p>
  <?php
  }
  ?>

[forum_amnesiac]

Have you tried it again since taking that field out.

PHP will not perform the record INSERT if you are trying to use a non-existent variable