INSERT INTO formvars & PHP

[Yrogerg]

I have a simple form that gathers info from a textbox (message). It checks if it's not blank and if not, stores 'message' and the date into MySQL. The problem is, it's only storing the date and not the message. Here's the script:

// php in the beginning of the file
<? 
	if($submit){
		$flag = true;
		include "../includes/connect.php";
		$date = date("m . d .y");
		if(empty($message) || $message = "")
			$error = "Please enter a message.";
		if(!$error){
			$query = "INSERT INTO updates set id = NULL, date = \"" . $date . "\", message = \"" . $message . "\"";
			mysql_query($query, $conn);
		}
	}
?>

// later in the html, form that gathers user input
<form action="" method="post" name="update" id="update">
			<input name="submit" type="hidden" value="submit">
              <table width="373" border="0" cellspacing="0" cellpadding="2">
                <tr class="global"> 
                  <td width="64" align="right" valign="top">Message</td>
                  <td width="301" align="left" valign="top">&nbsp; <textarea name="message" cols="50" rows="8" class="textbox" id="message"></textarea> 
                  </td>
                </tr>
                <tr class="global"> 
                  <td>&nbsp;</td>
                  <td><br> &nbsp; <input type="submit" name="Submit" value="Post Update"> 
                  </td>
                </tr>
              </table>
            </form>

// display script right beneath the form
<?
				if($flag){
					if($error)
						echo "<span class='notes'>".$error."</span>";
					else
						echo "<span class='notes'>This is the message you've posted:<br><br>".$date."<br>".$message."</span>";
				}	
			?>

[Rayn]

change this

if($submit){

to this

if($_POST['submit']){

and tell me what happends...

[Yrogerg]

same thang.

[dannys]

change:

 <td><br>   <input type="submit" name="Submit" value="Post Update"> 

to:

 <td><br>   <input type="submit" name="submit" value="Post Update"> 

PHP vars are case sensitive.

[Yrogerg]

Tried that too. Nada.

That can't be the problem b/c it's submitting, the date is inserted into MySQL and displays at the end on the page. If I leave the message field blank, it returns the error it should from the script. But if I type something in there, it goes through perfectly but the message isn't inserted into MySQL nor is it displayed on the page beneath the date.

If any else knows of a better way to do this, please let me know.

[Yrogerg]

::bump::

(sorry, i'm desperate.)