Problem with a form

[almightyegg]

I'll start with the codes:

The Form:

<form action="/chat/index.php" method="POST">
Message: <input type="text" name="message"><br>
<input type="submit" value="Post">
</form>

 

Index.php:

<?
$message = $_POST['message'];
if(isset($message)){
$timestamp = date("d-m-Y H:i:s");
$insert = mysql_query("INSERT INTO chat (`timestamp`, `userid`, `message`)
		VALUES('$timestamp', '{$mem['id']}', '" . mysql_real_escape_string($message) . "')") or die(mysql_error());
unset($message);
}
?>

It shows no errors it just isn't inserting the info.........I have no idea why?!?

 

also a question, once it is working, and I've unset $message if the user refreshes will it still see the $message, I'm not sure I can explain why I think it might still be there...so thought I'd ask...

[LemonInflux]

a) check the mysql details?

b) I don't think it would stay there.

[almightyegg]

ooh, it was because of an ajax script getting in the way somehow...so that's fixed/...

 

But the $message still remains after being unset....how can I make it disappear?

[LemonInflux]

Not sure. Simplest form, just use $message = '';

[almightyegg]

That didn't work either...